A Database Backup Program
mysqlhotcopy is a Perl script that was originally written and contributed by Tim Bunce. It uses
LOCK TABLES, and
scpto make a database backup. It is a fast way to make a backup of the database or single tables, but it can be run only on the same machine where the database directories are located. mysqlhotcopy works only for backing up
ARCHIVEtables. It runs on Unix and NetWare.
To use mysqlhotcopy, you must have read access to the files for the tables that you are backing up, the
SELECTprivilege for those tables, the
RELOADprivilege (to be able to execute
FLUSH TABLES), and the
LOCK TABLESprivilege (to be able to lock the tables).
shell>Back up tables in the given database that match a regular expression:
shell>The regular expression for the table name can be negated by prefixing it with a tilde (“
shell>mysqlhotcopy supports the following options, which can be specified on the command line or in the
[client]option file groups.