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 -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
Instructs the utility not to abort the session or to rename the backup directory, but to add new files to the directory.
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.
Instructs the utility to save logging information to the named database and table.
Used to enable debugging information.