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.

Large Incremental backup sizes and Backup SQL per user script

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

  1. g18c

    g18c Member

    Joined:
    Jul 7, 2007
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
Loading...

Share This Page