mysqlhotcopy: Hot Backup of MySQL

mysqlhotcopy is designed to make stable copies of live MySQL databases.

Here "live" means that the database server is running and the database may be in active use. And "stable" means that the copy will not have any corruptions that could occur if the table files were simply copied without first being locked and flushed from within the server. It uses Lock Tables, Flush Tables and cp or scp policy to take back-up, then unlock tables. It is used for MyISAM and Archive Engines only and It can be run only on the same machine where the database directories are located.

More Info on back-up policies to be followed.



@kova