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!

Large Incremental backup sizes and Backup SQL per user script

Discussion in 'Data Protection' started by g18c, Jan 16, 2013.

  1. g18c

    g18c Member

    Jul 7, 2007
    Likes Received:
    Trophy Points:
    I am using Bacula and connecting to the server on a nightly basis.

    Because it backs up the tar.gz files in /backup/cpbackup Im finding that the incremental backups are still large (30% of the size of the weekly full backup)... I know for sure there is not 30% of data being added each night.

    I guess because the compression process changes the file a lot from one day to the next, even though the data may not have changed significantly on the users account /home/user/.

    What I am thinking is rather than use cPanel backup and sync the tar.gz files, instead I should sync /home/* for all users, and then have a script to backup the users database (perhaps in /backups/userdbs/{db-for-each-user}).

    Does anyone see any issues with this and is this likely to decrease the incremental changes (since html files will not have changed much between backups)?

    Any ideas what script I could use to dump the MySQL databases on a per user basis?

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