Binary Backup
- To make a binary backup that consists of all files used by
InnoDB to manage its tables, use this procedure:
- Shut down the MySQL server and make sure that it shuts down without errors.
- Copy all
ibdata and .ibd files into a safe place.
- Copy all
ib_logfile files to a safe place.
- Copy the
my.cnf configuration file to a safe place.
- Copy all the
.frm files for InnoDB tables to a safe place.
- In addition to making binary backups as just described, also run
mysqldump.
- A binary file might be corrupted without noticing it.
- Dumped tables are stored into text files that are human-readable.
- Spotting table corruption becomes easier.
- Because the format is simpler, the chance for serious data corruption is smaller.
How do I recover this backup?
© 2007 John Michael Pierobon
Notes