CPbackup /var/lib/mysql empty tar.

ChrisAk

• July 09, 2014 06:49

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!

• 

  24x7server

  • July 10, 2014 00:09

  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

  0
• 

  ChrisAk

  • July 10, 2014 08:03

  I have these in my log: [QUOTE] /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: /var/cpanel/dnsadmin/sock: socket ignored /bin/gtar: Removing leading `/' from hard link targets /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names /bin/gtar: Removing leading `/' from member names [backup] System backups will not be uploaded to any remote destinations
  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.

  0
• 

  cPanelMichael

  • July 15, 2014 15:25

  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.

  0
• 

  ChrisAk

  • July 18, 2014 06:50

  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 [quote] /bin/gtar: /var/cpanel: file changed as we read it [backup] Failed to perform full backup of /var/cpanel/ to /home/backup/2014-07-18/system/dirs/_var_cpanel.tar.gz
  Any suggestions?

  0
• 

  ChrisAk

  • July 21, 2014 06:57

  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.

  0
• 

  cPanelMichael

  • July 23, 2014 17:45

  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.

  0
• 

  ChrisAk

  • July 25, 2014 08:20

  Hello, Just opened a ticket with id 5260551 . Thank you!

  0
• 

  cPanelMichael

  • July 25, 2014 15:21

  To update, it was suggested to update the data directory in the /etc/my.cnf file as a workaround. Thank you.

  0

Please sign in to leave a comment.