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.

Last updated 16 Aug 2024