PC Data Backups

How do I back up and restore a MySQL database?

1. First you will need to create a backup copy of your MySQL database on your local hard drive.
   
   • Please refer to the MySQL site for information on how to perform this action: MySQL Backup and Recovery
2. Next you will want to select the backup copies of this database, for backup offsite with PC Data Backups software.
   • This link will explain how to select files or folders: Screen shots - Selecting Files or Folders
   • Be sure to verify that the correct files are selected for backup and that they are backing up correctly.
     You can do this by performing Step 1) of the RESTORE operation described below, and restoring the database file to an alternate location as a test.
     View this document for more information: Test Restore

II. RESTORE - This is also a two step process.

1. First you will want to retrieve the backed up database files from your PC Data Backups account.
   
   • Here’s how: Screen shots - Retrieving files or folders
2. Next you will want to refer to the MySQL website for instructions on how to restore your database file in MySQL.
   
   • Here’s the link: TMySQL Backup and Recovery