I backup my accounts via cpanel backup. I run incremental and mount to a NAS. I have about 2GB in database and 3GB in files (500,000+ PNGs). Backup is hard on the server and it takes 17 hours to complete according to my logs. There must be a better option. Any advice?
Hi, The problem is that cPanel creates tarballs of the backups it creates and the gzip compression takes a lot of cpu time. You might want to look into some of r1soft's products but they are kind of pricey. For your situation you might want to look into rsync and mysqlhotcopy or http://www.innodb.com/hot-backup/order/
If your server has provision to attach new drive then you can take backup in second drive or you may purchase the backup space from third party like bqbackup. They will allow you to rsync data from your server to their server. Kailash
would rsync to another server be less intensive? btw, when cpanel backup runs, it runs with rsync as the process, so I don't understand this rsync suggestion when it's already being used
cPanel runs rsync for weekly and monthly backups. For daily backup, it uses pkgacct command. rsync will only copies the modified files to the destination and generally the backup providers provide high transfer rate to copy the data on that server. As you have total 5 GB data. Considering your database is updated daily (2 gb) but I think you are not updating your files daily so you will need to take only 2 gb + update files backup so I am sure it will take less than 17 hrs to rsync the data to remote server. If you want to complete the backup more faster, I would suggest to attache another drive and take backup locally. Kailash