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