InnoDB Storage EngineInnoDB storage engine has support for transactions and automatic crash recovery.
InnoDB data files do not contain consistent data due to a crash, InnoDB reads its logs and finds in them the list of pending committed and non-committed transactions that have not been flushed to the data files.
InnoDB automatically rolls back those transactions that were not committed.
InnoDB flushes to its data files those that were committed.
What is a good backup strategy?
© 2007 John Michael Pierobon