Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,897
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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 :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. mrishadali

    mrishadali Registered

    Joined:
    Apr 23, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,897
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. mrishadali

    mrishadali Registered

    Joined:
    Apr 23, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,897
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice