#1 (permalink)  
Old 12-23-2008, 10:07 AM
Registered User
 
Join Date: Dec 2008
Posts: 3
Neo321 is on a distinguished road
Question WHM mysql backup failed strangely

Hi all,

I am having a very busy LAMP server with about 10 GBs of database.
The server gets an average of 100 HTTP requests per second, & hence the server always has 500+ active persistent connections as I can judge using the mysql command " SHOW PROCESSLIST"

I used the whm backups to backup the user with all databases.

Strangely, when I extracted the backup tarballs, I found that all small databases had complete sql dump file with all the data, except the one whose size is 10 GB.
Here are the contents of the file "/cpbackup/monthly/mydomain/mysql/database_name.sql"
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

Its very strange, that the rest of the DB backups are fine & this one got messed.

Can anyone suggest some reason for this strange behaviour?
Server configuration is dual xeon cpu quad,i.e., 8 cores, & 8 GB of RAM.


Thanks...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 06-29-2009, 10:46 AM
Registered User
 
Join Date: Jun 2009
Posts: 2
praystone is on a distinguished road
I have this ploblem too, seems WHM canot surport to backup over 10 GBs of database.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 08:48 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
© cPanel Inc