# ARCHIVING routing # stop sguild /etc/init.d/sguild stop # stop mysql /etc/init.d/mysql stop # do the move cd /var/lib/mysql/sguildb ; find . -name \*200803\* -print -exec mv {} /var/lib/mysql/sguildb_archive \; # start mysql /etc/init.d/mysql start # Log into mysql mysql -h localhost -u root -p # dump the merge tables DROP TABLE sancp, event, data, icmphdr, tcphdr, udphdr; # start sguild /etc/init.d/sguild start