MySQL Reference Manual :: 8.9 The mysqlhotcopy Database Backup Program

--help, -?

Display a help message and exit.

--allowold

Don't abort if target exists (rename it by adding an _old suffix).

--checkpoint=db_name.tbl_name

Insert checkpoint entries into the specified db_name.tbl_name.

--debug

Enable debug output.

--dryrun, -n

Report actions without doing them.

--flushlog

Flush logs after all tables are locked.

--keepold

Don't delete previous (renamed) target when done.

--method=#

Method for copy (cp or scp).

--noindices

Don't include full index files in the backup. This makes the backup smaller and faster. The indexes can be reconstructed later with myisamchk -rq for MyISAM tables or isamchk -rq for ISAM tables.

--password=password, -ppassword

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.

--port=port_num, -P port_num

The TCP/IP port number to use when connecting to the local server.

--quiet, -q

Be silent except for errors.

--regexp=expr

Copy all databases with names matching the given regular expression.

--socket=path, -S path

The Unix socket file to use for the connection.

--suffix=str

The suffix for names of copied databases.

--tmpdir=path

The temporary directory (instead of /tmp).

--user=user_name, -u user_name

The MySQL username to use when connecting to the server.