Posts Tagged ‘repair MySQL’

How Do I Repair MySQL Tables?

Tuesday, August 3rd, 2010

On Windows

First back up your database as follows http://support.grouplogic.com/?p=1656

Once the backup is complete:

  1. – Click on Catalogs in the MySQL Administrator
    –┬áSelect mtdatabase in the Schemata window on the left
    – Click the Maintenance button
    – Select Repair Tables option
    – Select Use FRM options
    – Click the Repair Tables button
  2. Redo the backup
  3. Restart MassTransit.

On Mac

First back up your database as follows http://support.grouplogic.com/?p=1657

Once the backup is complete:

  1. – Click on Catalogs in the MySQL Administrator
    – Select mtdatabase in the Schemata window on the left
    – One by one, highlight a table
    – Click Table Actions at the bottom
    – Select Repair Table
    – Select Use FRM
  2. Make another backup
  3. Restart MassTransit.