( mysqlhotcopy

Info Catalog ( mysqldump ( Client-Side Scripts ( mysqlimport
 8.9 The `mysqlhotcopy' Database Backup Program
 `mysqlhotcopy' is a Perl script that was originally written and
 contributed by Tim Bunce. It 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 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 `MyISAM' and `ISAM'
 tables.  It runs on Unix, and as of MySQL 4.0.18 also on NetWare.
      shell> mysqlhotcopy DB_NAME [/PATH/TO/NEW_DIRECTORY]
      shell> mysqlhotcopy DB_NAME_1 ... DB_NAME_N /PATH/TO/NEW_DIRECTORY
 Back up tables in the given database that match a regular expression:
      shell> mysqlhotcopy DB_NAME./REGEX/
 The regular expression for the table name can be negated by prefixing it
 with a tilde (`~'):
      shell> mysqlhotcopy DB_NAME./~REGEX/
 `mysqlhotcopy' supports the following options:
 `--help, -?'
      Display a help message and exit.
      Don't abort if target exists (rename it by adding an `_old'
      Insert checkpoint entries into the specified DB_NAME.TBL_NAME.
      Enable debug output.
 `--dryrun, -n'
      Report actions without doing them.
      Flush logs after all tables are locked.
      Don't delete previous (renamed) target when done.
      Method for copy (`cp' or `scp').
      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.
      Copy all databases with names matching the given regular
 `--socket=PATH, -S PATH'
      The Unix socket file to use for the connection.
      The suffix for names of copied databases.
      The temporary directory (instead of `/tmp').
 `--user=USER_NAME, -u USER_NAME'
      The MySQL username to use when connecting to the server.
 `mysqlhotcopy' reads the `[client]' and  `[mysqlhotcopy]' option groups
 from option files.
 To execute `mysqlhotcopy', you must have access to the files for the
 tables that you are backing up, the `SELECT' privilege for those
 tables, and the `RELOAD' privilege (to be able to execute `FLUSH
 Use `perldoc' for additional `mysqlhotcopy' documentation:
      shell> perldoc mysqlhotcopy
Info Catalog ( mysqldump ( Client-Side Scripts ( mysqlimport
automatically generated byinfo2html