Summary

Backup

• mysqldump creates a dump file of SQL statements.

• mysqlhotcopy copies the data files to a backup location.

• BACKUP TABLE copies the data file for a table to a backup location.

• You can manually back up by locking and flushing the tables and then copying the files.

Restoration

• Reload dump files from mysqldump .

• Copy back data files from mysqlhotcopy or a manual backup.

• Restore from BACKUP TABLE with RESTORE TABLE .

• Re-execute operations since the backup from the binary log.

Checking and Repairing Tables

• Check tables with CHECK TABLE , myisamchk , isamchk , or mysqlcheck .

• Repair tables with REPAIR TABLE , myisamchk , isamchk , or mysqlcheck .

• Don't use myisamchk while the server is being used.