Backup and Recovery
A good maintenance plan for any database system includes a means to preserve the data. The main objective is to archive the data in case of failure or accidental loss. There are many ways you can backup and restore data in MySQL. The two most prominent methods are the MySQL Backup feature and the mysqldump utility. The following sections describe these methods and related backup topics.
Why we make backups
The MySQL Backup Feature
Starting in versions 5.5 and 6.0 betas, MySQL has provided the MySQL Backup feature which is comprised of two SQL commands (BACKUP DATABASE and RESTORE) as well as a command line utility (mysqlbackup).
Backing up data
Using MySQL Backup and point-in-time recovery
The backup logs
Third Party Tools
There are a number of third-party tools that you can use such as the following.
- Physical file copy
- Zmanda Recovery Manager
- Innobase's InnoDB Hot Backup
- Logical Volume Manager snapshots