Database Restoration

To restore a back up of your MySQL database, follow these steps:

1. Launch Windows Command Prompt and navigate to the MySQL bin folder by entering:
   • for a 32-bit version of Windows: cd "C:\Program Files\MySQL\MySQL Server 5.1\bin"
   • for a 64-bit version of Windows: cd "C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin"
   • for a MySQL installed on a custom location: cd "path to the custom location's MySQL bin folder"
2. Enter the following line by replacing the bolded parts with their corresponding values:

   mysql --user=MySQLUsername --password=MySQLPassword --default_character_set=utf8 < "SourcePath\BackupName.sql"

   
   (e.g. mysql --user=root --password=rootpassword --default_character_set=utf8 < "D:\MT SQL Backups\MTDB_7.sql")
   

   Note: Don't forget the quotes around the backup file location.The Destination path must be existing (e.g. C:), otherwise the The system cannot find the path specified. error message will appear and the restore will fail.

   If the backup file appears with size 0 or 1 KB, this means the credentials or syntax in the backup command have not been entered correctly

3. The selected database(s) will be restored.