MysqlDump and Mysqlhotcopy

[pankajit09]

Hello

I want to know about mysqlcump and mysqlhotcopy .

Which is better and why ?

If mysqldump is there then why mysqlhotcopy is developed ?

[ronverdonk]

Hello

I want to know about mysqlcump and mysqlhotcopy .

Which is better and why ?

If mysqldump is there then why mysqlhotcopy is developed ?

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 make a database backup quickly. It is 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 ARCHIVE tables. It runs on Unix and NetWare

The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server). The dump typically contains SQL statements to create the table, populate it, or both. However, mysqldump can also be used to generate files in CSV, other delimited text, or XML format.

If you are doing a backup on the server and your tables all are MyISAM tables, consider using the mysqlhotcopy instead because it can accomplish faster backups and faster restores.

You could have looked that up yourself in the MySQL documentation at mysqldump and mysqlhotcopy

Ronald :cool:

[kjbetz]

You could have looked that up yourself in the MySQL documentation at mysqldump and mysqlhotcopy

Ronald :cool:

While this is good and all... maybe he did look at the documentation. I don't know maybe he didn't.

But, I know I did and I still had questions. Sometimes it's nice to get the opinions from more experienced users / administrators that have maybe tried both.

Coming here from a Google search your reply does nothing in adding any insight into the topic.

[kjbetz]

I've found this discussion in the MySQL Lists:

mysql: mysqldump vs. mysqlhotcopy

[kjbetz]

I found this also to add some thoughts to the discussion:

MySQL Lists: mysql: Recommended backup scripts for mysql databases