InnoDB backup methods

from the Artful MySQL Tips List


There are four main backup methods:

1. Hot backup: Use the mysqlbackup tool in MySQL Enterprise Backup.

2. Cold (physical copy) backup: Do a error-free server shutdown. Copy all ibdata files and .ibd files, .frm files for InnoDB tables, ib_logfile files, and my.cnf/ini to a safe place.

3. Replication

4. Mysqldump

Details at https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html.



Return to the Artful MySQL Tips page