Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

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:

  1. Needs to be Mac software
  2. I'm on shared hosting
  3. My FTP client is Transmit
  4. 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!

share|improve this question
    
Are you open to hosted solutions that require a small annual fee (e.g. $20 a year), or does your solution absolutely have to be Mac-based and free? –  Nick Jul 7 '11 at 14:23
    
@Nick Yep mac based and free. We've just eaten our budget with a new CRM!! –  Rob Jul 7 '11 at 14:51
add comment

2 Answers

up vote 0 down vote accepted

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 http://username:password@domain.com:2082/getsqlbackup/databasename.gz --output-document=backupdir/databasename.gz

For backing up the files use this command

wget http://username:password@domain.com:2082/getbackup/sitename.tar.gz --output-document=backupdir/sitename.tar.gz
share|improve this answer
1  
Thanks. Yep definitely backup locally. Ok I'll give wget a go (I'll probably be back for more help on that!!). I'm using the FTP client Transmit so just trying to find out if it can backup automatically. –  Rob Jul 6 '11 at 10:25
1  
I checked out the manual option and I found it uses a similar command to the databases and so can be automated too. Bear in mind that the file it creates is a "zipped tar" file so you'll need an unzip program that knows what to do with it. –  paulmorriss Jul 6 '11 at 14:14
add comment

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.

share|improve this answer
    
From what I saw, it was manual... I don't think I was looking at the wrong thing. –  Rob Jul 6 '11 at 12:18
    
It should be automatic. I know mine is and I don't have anything special. If you don't see an option for "Backup Interval" then your cPanel might not offer this. Probably because it is a shared hosting environment. –  John Conde Jul 6 '11 at 13:10
    
Yep that's the reason, it is shared. –  Rob Jul 6 '11 at 13:13
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.