MySQL Disaster Recovery…

Within a couple of weeks of doing our disaster recovery testing we’ve had a number of disasters, one of which was our Bugzilla server. The recovery was pretty sweet. The database engine (mySQL) was loaded as part of the Linux install and recovering the database was done with one command:

mysql -u root –password=”myPassword” bugs < backup.sql