: 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
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!
More posts by @Steve110
2 Comments
Sorted by latest first Latest Oldest Best
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.
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
Terms of Use Create Support ticket Your support tickets Stock Market News! © vmapp.org2024 All Rights reserved.