Name
mysqlhotcopy
Synopsis
mysqlhotcopydatabase
[path
]
Use this to make backup copies of databases while the server is
active. It only works on MyISAM and ISAM tables, though. It makes a
simple copy of each database directory and each table file. This
results in a separate directory for each database and usually three
files for each table: one for the schema, another for the data, and a
third for the index. It places a read lock on all of the tables in
the database while copying them. Here is an example of how you can
copy a database with mysqlhotcopy
:
mysqlhotcopy -u russell -p password db1 /tmp/backup
Note that unlike other MySQL utilities, there is a space between the
-p
and the password. Next the database
(db1) is specified. Finally, the path to write
the backup directories is given. To restore databases or tables that
were copied by mysqlhotcopy
, just copy the table
files to be restored to their original data directories. Here are the
following options:
-
--addtodest
Instructs the utility not to abort the session or to rename the backup directory, but to add new files to the directory.
-
--allowold
Instructs the utility to rename an existing backup directory to *_old so that the copying may be completed. If the new copy is successful, the old directory is deleted. If it’s unsuccessful, the old directory is restored.
-
--checkpoint=
database.table
Instructs the utility to save logging information to the named database and table.
-
--debug
Used to enable debugging information.
-
--dryrun, ...
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.