MySQL Restore Test

Your blogs are safely backed up every day (and now I know for sure.) Finally got around to verifying that the daily backups using AutoMySQLDump can be used to restore the entire database. I ran a mini disaster recovery using the old iMac.

Note to self: Kept trying to use the command “mysqldump” to restore, but that is an output only command. Just using “mysql” and reversing the out character > with the in character < did it:

root# /usr/local/bin/mysql -umxxxxx -pgxxxxx mov_type < /2004-10-17.Sunday.sql

(User and password masked.)

Leave a Reply

Your email address will not be published. Required fields are marked *