Backup of running MySql

[Ben Clewett]

Dear MySql,

I have a slave which is used only to keep a backup of a 100% InnoDB system. It accept no connections.

Currently I stop the process, backup the file system and start the process.

I'm trying to speed this up, by taking a live LVM snapshot when MySql is running, and wonder if members could comment whether this is safe:

mysql> STOP SLAVE;
mysql> FLUSH TABLES;

(Take LVM snapshot)

mysql> START SLAVE;

Any comments, improvements, warnings etc, very welcome!

Ben