Recover

• To recover an InnoDB database to the present from the binary backup run MySQL server with binary logging turned on.
  • Apply the binary log to the backup database to achieve point-in-time recovery:

    mysqlbinlog hostname-bin.1234 | mysql

• To recover from a crash of a MySQL server, the only requirement is to restart it.
  • InnoDB automatically checks the logs and performs a roll-forward of the database to the present.
  • InnoDB automatically rolls back uncommitted transactions that were present at the time of the crash.

How do I move an InnoDB database to another machine?

---

---

© 2007 John Michael Pierobon

Notes