Backups

[andychev]

I know you are very good at backing up sites and taking care of this. However i was wondering whether the following would be possible?

Is it possible to somehow automatically download a backup weekly to my computer? And an automatic daily backup of databases?

Ideally these would be stored sequentially on my server?

Thoughts and pointers much appreciated.

[jmarcv]

I don't think cPanel allows access to the backups other than to be able to restore them.

For mysql, you could setup a cron to create a backup that you could download.

 
mysqldump --opt -u <cPanel user> -p <cPanel pass> <database name> >backup.sql

So if your cPanel login was
andychev
$3cr37

and your database was
main (which in reality is called andychev_main)

You would do this:

 
mysqldump  --opt  -u andychev -p $3cr37 andychev_main>/home/andychev/www/backup.sql

You might want to consider creating a mysql user with read access to the database and use that instead of having your cpanel info sitting in a cron file, though its probably not a real big deal.

[infoserv]

Wow, this forum is great. I just picked up another great tip here.

[lgutman]

Try CpSiteSaver I just started using it. Works very well for backing up cpanel sites as well as mysql dbs inside of cpanel.

Larry

[charlesh]

I've been using Cpanel's backup feature and it works very well.

Chas