How to dump an MySQL/InnoDB database
Answer:
To do a point-in-time SQL dump of a InnoDB database, use the mysqldump command with the --single-transaction flag
# mysqldump --master-data=2 --single-transaction huge_db > backup.sql
The binlog position will be written in the backup.sql, which is very useful for database recovery if needed.
[...] MySQL, the only way to REORG a table is to export the data, e.g. using mysqldump, then import the data into MySQL [...]