Sasha Pachev wrote:
The best way to back up a large MySQL database is via an LVM snapshot. If that is not available, second best is FLUSH TABLES WITH READ LOCK, tar the database directory, then UNLOCK TABLES. There is a script mysqlsnapshot that does it for you <snip>
Sasha, Informative and accurate as usual. What about InnoDB tables? --Dave /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
