mysqlhotcopy is a perl script that uses LOCK TABLES, FLUSH TABLES and cp or scp to quickly make a backup of a database. It's the fastest way to make a backup of the database, but it can only be run on the same machine where the database directories are.
The Definitive Guide to MySQL 5 - Google Books Result::
href=http://books.google.com/books?id=s_87mv-Eo4AC&pg=PA357&lpg=PA357&dq=mysqlhotcopy+function+%3F&source=web&ots=tbUzAbOCqf&sig=mUCpjnCyuetR5G1PfU6EMGza_hA&hl=en&sa=X&oi=book_result&resnum=9&ct=result class=l onmousedown=return clk(http://books.google.com/books?id=s_87mv-Eo4AC&pg=PA357&lpg=PA357&dq=mysqlhotcopy+function+%3F&source=web&ots=tbUzAbOCqf&sig=mUCpjnCyuetR5G1PfU6EMGza_hA&hl=en,,,res,35,)>The Definitive Guide to MySQL 5 - Google Books Resultby Michael Kofler, David Kramer - 2005 - Computers - 748 pagesMaking a Backup In the simplest case, the use of mysqlhotcopy is as follows: root# function as they do with all MySQL tools, but with one exception.
http://books.google.com/books?id=s_87mv-Eo4AC&pg=PA357&lpg=PA357&dq=mysqlhotcopy+function+?&source=web&ots=tbUzAbOCqf&sig=mUCpjnCyuetR5G1PfU6EMGza_hA&hl=en&sa=X&oi=book_result&resnum=9&ct=resultHOME |
mysqlhotcopy db_name [/path/to/new_directory]
mysqlhotcopy db_name_1 ... db_name_n /path/to/new_directory
mysqlhotcopy db_name./regex/
questions again, mysqlhotcopy is this used to backup the actual database files in the mysql data directory i.e. /var/lib/mysql/mydatabase ?
I've never looked at the mysqlhotcopy script, but yes this is the same as using mysqldump... except it will flush and then lock the database tables before doing the dump. So, if you are backing up a server that is running, using this script would be safer then just a mysqldump alone.
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market
|
