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

Last updated 16 Aug 2019

Return to the Artful MySQL Tips page