In the MySQL team, we are considering deprecating the
mysqlhotcopy utility. To provide some background, here is an excerpt from the MySQL manual:
mysqlhotcopy is a Perl script that was originally written and contributed by Tim Bunce. It uses FLUSH TABLES, LOCK TABLES, and cp or scp to make a database backup. It is a fast 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 ARCHIVE tables. It runs on Unix.
And now let me explain the motivations leading to our proposal:
- The name implies that this utility will work for ‘MySQL’ and is hot, but actually neither are true:
- Only MyISAM