mysqlhotcopy Backup Problem

Schiz0 · 02-05-2008, 04:08 PM

I'm having a problem with the mysqlhotcopy script.

Code:

$ /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.

Yaniv-Fer · 02-06-2008, 08:24 AM

Hello Schiz0

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

i am using this to backup mysql DB's

export database

Code:

mysqldump -u root -p DB-NAME > /path/to/backup/filename

import database

Code:

mysql -u root -p DB_NAME < BACKUP_FILE_NAME

i successfully created and restored with this
bugtracker (MANTIS) DB's
and
mediawiki DB's

Yaniv

Schiz0 · 02-06-2008, 09:23 AM

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).