Optimizing and Repairing MassTransit Databases

From time to time you may need to repair or optimize your MassTransit databases.

Warning: Make sure you have backed up your database (see Database Backup Process for instructions).

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"

Enter the following line by replacing the bolded parts with their corresponding values:

mysqlcheck --user=MySQLUsername --password=MySQLPassword --auto-repair --optimize --all-databases