469,076 Members | 1,377 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,076 developers. It's quick & easy.

MysqlDump and Mysqlhotcopy

296 100+
Hello

I want to know about mysqlcump and mysqlhotcopy .

Which is better and why ?

If mysqldump is there then why mysqlhotcopy is developed ?
Jan 17 '07 #1
4 15694
ronverdonk
4,258 Expert 4TB
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:
Jan 17 '07 #2
kjbetz
3
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.
Apr 12 '07 #3
kjbetz
3
I've found this discussion in the MySQL Lists:

mysql: mysqldump vs. mysqlhotcopy
Apr 12 '07 #4
kjbetz
3
I found this also to add some thoughts to the discussion:

MySQL Lists: mysql: Recommended backup scripts for mysql databases
Apr 12 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Mangina | last post: by
7 posts views Thread by Adam Smith | last post: by
reply views Thread by Brian | last post: by
3 posts views Thread by Christopher Mouton | last post: by
1 post views Thread by Greg.Harabedian | last post: by
reply views Thread by jmichel | last post: by
6 posts views Thread by Antoni | last post: by
2 posts views Thread by Antoni | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.