# 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