473,394 Members | 1,221 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

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 15923
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

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

Similar topics

4
by: Mangina | last post by:
Hello all. Can anyone see why this snippet of code isnt dumping the databases using mysqldump ? All the credentials are correct (changed for the purpose of this post). $host = "localhost";...
7
by: Adam Smith | last post by:
Hope this is the right news group!! I did a server upgrade and at the same time did a mysql update from 4.0.12 to Ver 12.22 Distrib 4.0.16 mach1# mysql --version mysql Ver 12.22 Distrib...
0
by: Brian | last post by:
Hi, I'm trying to script a backup program using mysqlhotcopy. I've got the script in /root/ and i'm calling mysqlhotcopy from there. I can get the script to work if i pass the password on the...
3
by: Christopher Mouton | last post by:
We regularly make drive images of our entire server and store it at a backup site. To be honest I have never fully understood how the imaging programs deal with open files. My question is will the...
1
by: Greg.Harabedian | last post by:
I'll start off by saying I am using MySQL v4.0 and my question is...how do I get mysqldump to dump the actual binary values store in a blob? Here is an example: -- Create a test table create...
0
by: jmichel | last post by:
alright, heres the problem, I setup a backup routine to backup my daabase at night under another name and then do a dump on that backup database so that my users can still acces the site while I do...
6
by: Antoni | last post by:
Hello, I'm trying to make a daily database backup. When executing "mysqldump - uxxx -pxxx database /home/backup/ddbb.sql -q &" the httpd server gets blocked and my site is "offline" for 30...
2
by: Antoni | last post by:
I tried using mysqlhotcopy to do backup copies of my databases, but it fails with error: "DBD::mysql::db do failed: Not unique table/alias: 'comments' at /usr/ bin/mysqlhotcopy line 466." Has...
0
by: Pratchaya | last post by:
How can i dump (mysqldump) with skip query logging ? Now, when i run mysqldump. mysql log ( query log ) default running/keeping all in result mysqldump. It's possible ? to run mysqldump...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.