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.

CPbackup /var/lib/mysql empty tar.

Discussion in 'Data Protection' started by ChrisAk, Jul 9, 2014.

  1. ChrisAk

    ChrisAk Member

    Joined:
    Jul 9, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    I have scheduled my backups to run daily and also backup system dirs.
    I noticed that under /home/backup/2014-07-08/system/dirs the _var_lib_mysql_.tar.gz is created empty.
    Are there any log files on this to see why this happens?
    Also i've set to transfer backups to remote host but i noticed that only the user account backups are transfered and not the system dirs. I can't seem to find an option to transfer system dirs too, is this the defauly behavior? Any way to change this?

    Thanks in advance!
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    Can you please review the backup logs with /usr/local/cpanel/logs/cpbackup/ directory and FTP backup activity logs in /usr/local/cpanel/logs/cpbackup_transporter.log file
     
  3. ChrisAk

    ChrisAk Member

    Joined:
    Jul 9, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I have these in my log:
    Afterwards there are individual account backups. No mention about what's doing on system dirs and why system backups will not be uploaded to any remote destinations.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    System backups are not uploaded to remote destinations by default. You have to enable that manually per the instructions at:

    Remote System Backups

    Note that you may want to see if the MySQL directory backs up successfully on the next backup generation.

    Thank you.
     
  5. ChrisAk

    ChrisAk Member

    Joined:
    Jul 9, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello Michael and thanks for the reply!
    I added "upload_system_backup: 1" as suggested in the configuration file and now it uploads system dirs to remote location too.
    Problem is i still have problem with /var/lib/mysql which is tared empty, also i now get this error
    Any suggestions?
     
  6. ChrisAk

    ChrisAk Member

    Joined:
    Jul 9, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    So after a small investigation i found out that /var/lib/mysql is a symlink to /home/mysql. Could someone please tell me where is the backup script so i can change the mysql location to /home/mysql so it takes the backup? Atm it backups only the symlink and not the actual directory. Need to add -h option to tar or replace the symlink dir with the actual location of it.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    It's not possible to modify the backup script to change how it handles symlinks. You can submit a bug report for the issue with symbolic link backing up instead of the MySQL directory via:

    Submit A Bug Report

    Feel free to post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
  8. ChrisAk

    ChrisAk Member

    Joined:
    Jul 9, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,
    Just opened a ticket with id 5260551 .
    Thank you!
     
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page