Bug #31867 Document on how to backup innodb tables without shutting down mysql is incomplet
Submitted: 26 Oct 2007 6:17 Modified: 29 Oct 2007 18:09
Reporter: Bogdan Kecman Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S2 (Serious)
Version:all OS:Any
Assigned to: Jon Stephens CPU Architecture:Any

[26 Oct 2007 6:17] Bogdan Kecman
Description:
15.1.1.6. Creating a Data Snapshot Using Raw Data Files
http://dev.mysql.com/doc/refman/5.1/en/replication-howto-rawdata.html

Part of the document explaining how to get a snapshot of the system from a master without shutting down the database ... tried that 3 times on different servers, after successful read lock, copy of the innodb is corrupted and cannot be restored.

How to repeat:
Follow the document and copy your innodb files to another server

Suggested fix:
I'm not too familiar with InnoDB so there must be some additional task after acquiring table lock before one should start to copy the innodb files. Whatever that task is, should be explained here.
[29 Oct 2007 18:09] Jon Stephens
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.