LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 02-05-2008, 04:08 PM   #1
Schiz0
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.
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.
 
Old 02-06-2008, 08:24 AM   #2
Yaniv-Fer
Member
 
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
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
 
Old 02-06-2008, 09:23 AM   #3
Schiz0
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).
 
  


Reply

Tags
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


All times are GMT -5. The time now is 12:40 PM.

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