The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

WHM mysql backup failed strangely

Discussion in 'Data Protection' started by Neo321, Dec 23, 2008.

  1. Neo321

    Neo321 Registered

    Joined:
    Dec 23, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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...
     
  2. praystone

    praystone Registered

    Joined:
    Jun 29, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    I have this ploblem too, seems WHM canot surport to backup over 10 GBs of database. :confused:
     
Loading...

Share This Page