All pastes #976830 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-04-08 13:25 UTC
rendered paste body
# ARCHIVING routing
cd /var/lib/mysql/sguildb ; find . -name \*200803\* -print -exec mv {} /var/lib/mysql/sguildb_archive \;
# stop sguild
/etc/init.d/sguild stop
# restart mysql
/etc/init.d/mysql restart 
# Log into mysql
mysql -h localhost -u root -p
# dump the merge tables
DROP TABLE sancp, event, data, icmphdr, tcphdr, udphdr;
# restart sguild
/etc/init.d/sguild start