Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 02-05-2008, 04:08 PM   #1
LQ Newbie
Registered: Dec 2005
Location: Pennsylvania, USA
Distribution: FreeBSD, Ubuntu, and Debian
Posts: 10

Rep: Reputation: 0
Exclamation mysqlhotcopy Backup Problem

I'm having a problem with the mysqlhotcopy script.
$ /usr/bin/mysqlhotcopy --user=root --password=pass --socket=/path/to/mysqld.sock db1 /root/backups/db-backup/
Locked 59 tables in 0 seconds.
Flushed tables (<insert a bunch of my tables here>) in 0 seconds.
Copying 178 files...
Copying indices for 0 files...
Unlocked tables.
mysqlhotcopy copied 59 tables (178 files) in 0 seconds (0 seconds overall).
However, nothing exists in the /root/backups/db-backup/db1/ dir at all :-\

It seems that mysqlhotcopy is failing to copy the files over out of /var/lib/mysql/db1/ ?

Has anyone else ever had this problem?

Thanks for your time.
Old 02-06-2008, 08:24 AM   #2
Registered: Feb 2006
Distribution: Fedora,Solaris
Posts: 46

Rep: Reputation: 15
Hello Schiz0

if a normal database dump is also good for you...

i am using this to backup mysql DB's

export database
mysqldump -u root -p DB-NAME > /path/to/backup/filename
import database
mysql -u root -p DB_NAME < BACKUP_FILE_NAME
i successfully created and restored with this
bugtracker (MANTIS) DB's
mediawiki DB's

Old 02-06-2008, 09:23 AM   #3
LQ Newbie
Registered: Dec 2005
Location: Pennsylvania, USA
Distribution: FreeBSD, Ubuntu, and Debian
Posts: 10

Original Poster
Rep: Reputation: 0
Well the reason I'm using mysqlhotcopy INSTEAD of mysqldump is because my database is way too big. mysqldump takes over an hour to run everything, while mysqlhotcopy is extremely quick (because it copies the raw files on the filesystem).


backup, database, mysql

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Backup problem svyshna Linux - General 1 10-17-2005 03:17 PM
mysql 4.1.7 mysqlhotcopy perl issue dtra Linux - Software 1 05-10-2005 09:11 AM
mysqlhotcopy issue dtra Linux - Software 0 04-27-2005 07:55 PM
mysqlhotcopy mnauta Linux - General 1 01-18-2004 02:18 AM
Help with Backup problem MrJoshua Linux - Newbie 0 04-08-2002 01:53 PM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 01:33 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration