All pastes #976843 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-04-08 13:35 UTC
rendered paste body

# 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