LinuxQuestions.org
Register a domain and help support LQ
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 12-25-2007, 05:43 PM   #1
cabron
LQ Newbie
 
Registered: Apr 2007
Posts: 8

Rep: Reputation: 0
Rsync not backing up MySQL


I have an rsync set up on my server, but the problem is that the mysql databses aren't backed up.

The sql files exist in the backup but are empty.

Any ideas what the problem might be?
 
Old 12-25-2007, 07:40 PM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
They're empty where rsync is copying them over or from the source directory? A little more details how your rsync is backing up your files might be helpful, along with permissions and what user is used to do the backups, etc.
 
Old 12-25-2007, 08:04 PM   #3
cabron
LQ Newbie
 
Registered: Apr 2007
Posts: 8

Original Poster
Rep: Reputation: 0
It's a backup set up from WHM. The original databases are ok, but when they get backed up the copies are empty.
 
Old 12-26-2007, 08:56 AM   #4
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Quote:
Originally Posted by cabron View Post
It's a backup set up from WHM. The original databases are ok, but when they get backed up the copies are empty.
Sounds like a permissions issue. What is the exact command used to rsync these over to the backup host and what are the permissions, along with the user/userid that owns these and what user is being used for the rsync?
 
  


Reply


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
backing up to the net with ftp or rsync rblampain Linux - General 2 04-27-2006 01:40 AM
rsync and backing up danimalz Linux - Software 12 10-24-2005 01:01 PM
backing up remote folder with rsync and ssh ohcarol Linux - Software 6 01-03-2005 01:43 AM
RSync or another way? Backing Up Off-site. kemplej Linux - Software 0 08-19-2004 05:55 PM


All times are GMT -5. The time now is 04:00 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