Database Backup

When it is important to keep track of the MassTransit transfers, users, mailboxes, etc., backups of the MassTransit folders and MySQL database(s) should be run on a regular basis. Test your backups on a regular basis. Make sure you can restore the MySQL database(s) and MassTransit folders as needed. This is best tested on a non-production server. Backups should be saved to a physically separate drive, volume, or another server if possible.

To create a MySQL backup, 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:
   
   mysqldump.exe --user=MySQLUsername --password=MySQLPassword --default-character-set=utf8 -cA > "DestinationPath\BackupName.sql"
   
   (e.g. mysqldump.exe --user=root --password=rootpassword --default-character-set=utf8 -cA > "D:\MT SQL Backups\MTDB_7.sql")
   

Note: In -cA the "A" must be a capital letter.

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 backup 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