8.11. mysqlhotcopy — A Database Backup Program
mysqlhotcopy is a Perl script that was
originally written and contributed by Tim Bunce. It uses
scp to make a database backup quickly. It
is the fastest 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
tables. It runs on Unix and NetWare.
Back up tables in the given database that match a regular
The regular expression for the table name can be negated by
prefixing it with a tilde
mysqlhotcopy supports the following
Display a help message and exit.
Do not rename target directory (if it exists); merely add
files to it.
Do not abort if a target exists; rename it by adding an
Insert checkpoint entries into the specified database
db_name and table
Base directory of the chroot jail in
which mysqld operates. The
path value should match that of
--chroot option given to
Enable debug output.
Report actions without performing them.
Flush logs after all tables are locked.
The hostname of the local host to use for making a TCP/IP
connection to the local server. By default, the connection
is made to
localhost using a Unix
Do not delete previous (renamed) target when done.
The method for copying files (
Do not include full index files in the backup. This makes
the backup smaller and faster. The indexes for reloaded
tables can be reconstructed later with myisamchk
The password to use when connecting to the server. Note
that the password value is not optional for this option,
unlike for other MySQL programs. You can use an option
file to avoid giving the password on the command line.
Specifying a password on the command line should be
considered insecure. See
Section 5.8.6, “Keeping Your Password Secure”.
The TCP/IP port number to use when connecting to the local
Be silent except for errors.
Record master and slave status in the specified database
db_name and table
Copy all databases with names that match the given regular
Reset the binary log after locking all the tables.
master.info file after
locking all the tables.
The Unix socket file to use for the connection.
The suffix for names of copied databases.
The temporary directory. The default is
The MySQL username to use when connecting to the server.
mysqlhotcopy reads the
[mysqlhotcopy] option groups from option
To execute mysqlhotcopy, you must have
access to the files for the tables that you are backing up,
SELECT privilege for those tables, and
RELOAD privilege (to be able to execute
perldoc for additional
mysqlhotcopy documentation, including
information about the structure of the tables needed for the