mysqldump

Dave Smith dave at thesmithfam.org
Thu Jan 1 11:25:35 MST 2009


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



More information about the PLUG mailing list