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.

Backup questions - mysql.sock: socket ignored

Discussion in 'Data Protection' started by privard, Sep 20, 2013.

  1. privard

    privard Member

    Joined:
    Aug 10, 2013
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    2 simple questions, but I've been looking hard and long on Google.

    First question is: Why is it always written this when I receive the "backup complete" email from cPanel using the new backup system:
    /bin/gtar: /var/lib/mysql/mysql.sock: socket ignored

    Second, my back is being done at 2am EDT, but even though the server is most likely empty (I do not get a lot of visitors during the day, so it's even quieter at night), I get the following error when backing up MySQL. What is the ibdata1 file? Please bare in mind that this is a second server, and it's not related to the above server in question 1.

    /bin/gtar: /var/lib/mysql/ibdata1: file changed as we read it
    /bin/gtar: /var/lib/mysql/mysql.sock: socket ignored
    [backup] Failed to perform full MySQL database backup

    Thank you!
     
  2. Aaron.Edwards

    Aaron.Edwards Active Member

    Joined:
    Sep 21, 2013
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    The MySQL socket error should be ignored as you cannot copy the socket file.


     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    It's normal for the socket file to be ignored. If you see "file changed as we read it", it indicates the database was not backed up due to MySQL activity during the backup process. Try checking the /etc/my.cnf file and see if the issue persists with an empty MySQL configuration file.

    Thank you.
     
  4. privard

    privard Member

    Joined:
    Aug 10, 2013
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks guys, I really appreciate the time you took to answer my questions :)
     
  5. mrishadali

    mrishadali Registered

    Joined:
    Apr 23, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi I am having the same problem, I am getting a "[backup] Backup complete on server" email with the following log

    The problelm is, there is alway MYSQL activity on the server because there are some applications running which use MYSQL database every minute.
    Do I have to stop those applications when the backup process is running? Can you help me with this?

    Thanks
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    The MySQL databases are still backed up through the "mysqldump" utility if you have databases backed up per account. The entire MySQL directory is what's failing to backup. You may want to disable the backup for the entire MySQL directory if you have database activity at all times.

    Thank you.
     
  7. mrishadali

    mrishadali Registered

    Joined:
    Apr 23, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thank you very much for your reply.
    today I got the following error
    gzip could not compress files. How do I fix this error?

    Thank you
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    It looks like the "Permission denied" error may be related to the backup mount. Is the NFS mount configured with any special permissions or ownership restrictions? Do you get the same error if you try backing up to a local directory that's not a NFS mount?

    Thank you.
     
Loading...

Share This Page