(mysql.info.gz) mysqlhotcopy

Info Catalog

(mysql.info.gz) mysqldump

(mysql.info.gz) Client-Side Scripts

(mysql.info.gz) 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.
 
 `--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.
 
 
 `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
 TABLES').
 
 Use `perldoc' for additional `mysqlhotcopy' documentation:
 
      shell> perldoc mysqlhotcopy
 

Info Catalog

(mysql.info.gz) mysqldump

(mysql.info.gz) Client-Side Scripts

(mysql.info.gz) mysqlimport