How to backup and import a MySQL InnoDB database
Sat, 01/19/2008 - 02:56 — sandip(via blog.spikesource.com)
Due to the way Innodb tables are structured, you cannot perform a hotback up of this database without using third party tools. Therefore you must take your database offline for a small period of time while you take the backup...