Mobile app version of vmapp.org
Login or Join
Steve110

: Auto backup website database using cpanel Is there a way to automatically backup a website database, say once a month? I have cpanel and WHM running on all my shared hosting packages. It has

@Steve110

Posted in: #Backups #WebHosting

Is there a way to automatically backup a website database, say once a month?

I have cpanel and WHM running on all my shared hosting packages. It has a backup option but it's manual.

Important info:


Needs to be Mac software
I'm on shared hosting
My FTP client is Transmit
It needs to be a free solution


Update:

We've got Dropbox so if there was some way to automatically grab the mysql databases say once a month that would be great. As all our other backups are there anyways. But in the first instance let's just try to get an automatic backup to my computer!

10.02% popularity Vote Up Vote Down


Login to follow query

More posts by @Steve110

2 Comments

Sorted by latest first Latest Oldest Best

 

@Sarah324

cPanel has built in back up functionality. It is found under Backup > Configure Backup. It can be set to run monthly and includes database data.

10% popularity Vote Up Vote Down


 

@Candy875

I'm presuming you want to back up somewhere locally, rather than push the data somewhere else on the internet.

The getsqlbackup command which comes with some versions of cPanel can backup your databases for you. You need to get wget and then write a local batch file/script like this:

wget username:password@domain.com:2082/getsqlbackup/databasename.gz --output-document=backupdir/databasename.gz


For backing up the files use this command

wget username:password@domain.com:2082/getbackup/sitename.tar.gz --output-document=backupdir/sitename.tar.gz

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme