OS X Client Server

Restoring

Now that you have a complete backup of your databases you need to know how to restore them in an emergency.

To restore a backup type:

mysql -u root -p -v < BackupName.sql

Doing this will Completely erase the current database and revert to the backup. Any data added since the backup will be gone. If you have critical data being added all the time you will have to also look into MYSQL Cluster or MYSQL Replication.

Pages: 1 2 3

This entry was posted on Friday, November 10th, 2006 at 5:13 am and is filed under OS X Web Server, OS X MYSQL, OS X Back up. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.