30.5. Enabling MyISAM Auto-RepairThe MySQL server can be instructed to check and repair MyISAM tables automatically. With automatic repair enabled, the server checks each MyISAM table when it opens it to see whether the table was closed properly the last time it was used and is not marked as needing repair. If the table is not okay, the server repairs it. To enable automatic MyISAM table maintenance, start the server with the --myisam-recover option. The option value can consist of a comma-separated list of one or more of the following values:
For example, to tell the server to perform a forced recovery of MyISAM tables found to have problems but make a backup of any table it changes, you can put the following lines in an option file: [mysqld] myisam-recover=FORCE,BACKUP |