InnoDB Backup and Recoveryο
InnoDB Backupο
Hot Backupsο
The mysqlbackup command, part of the MySQL Enterprise Backup component
Cold Backupsο
Perform a slow shutdown of the MySQL server and make sure that it stops without errors.
Copy all
InnoDB
data files (ibdata
files and.ibd
files) into a safe place.Copy all the
.frm
files forInnoDB
tables to a safe place.Copy all
InnoDB
log files (ib_logfile
files) to a safe place.Copy your
my.cnf
configuration file or files to a safe place.
Logical Backups Using mysqldumpο
In addition to physical backups, it is recommended that you regularly create logical backups by dumping your tables using mysqldump.
Tipsο
backup-mysql.sh
mysql-backup.sh
InnoDB Recoveryο
Point-in-Time Recoveryο
Recovery from Data Corruption or Disk Failureο
InnoDB Crash Recoveryο
The InnoDB crash recovery process consists of several steps:
Redo log application
Roll back of incomplete transactions
Change buffer merge
Purge