How To Set Up Automatic Backups of your Godaddy Website and Databases

I had a client that recently wanted to start backing up all of the data from his websites to an external hard drive. I was like, “Ok, that’s easy. GoDaddy creates daily backups of your files that you can zip up from your account and download.” Wrong.

Godaddy does create daily backs, which you can zip up and download, but not if your trying anything over 10 MB or so. Also, it DOES NOT create backups of your databases. But that’s ok, cron jobs to the rescue.

To create the necessary backups I needed to do the following:

1) Write a script that would generate backups of all the databases and store them in a private zone
2) Write a script that would create a zip file of the entire site
3) Add both of these as cron jobs

1) backupmydatabases


#!/bin/sh

// Just create a sql dump of the database.
mysqldump -uMYUSERNAME -pMYPASSWORD --opt -hMYHOSTNAME MYDATABASENAME > ~/private/access/MYDATABASENAME.sql
// Do this for each database that you need to backup

2) backupmyfiles


#!/bin/sh

// Remove the previous backup file.
rm -f ~/private/access/fullsite_backup.tar.gz

// Create a tarball file of everything in your pocket of the server
// Dont include the actual tarball!!
tar --exclude=~/private/access/fullsite_backup.tar.gz -czf ~/private/access/fullsite_backup.tar.gz ~/*

3) Godaddy Crons

Now you just go to your Godaddy account and setup 2 cron jobs to run each of those scripts. Make sure you run the database backup script first and allow enough time for it to finish before you start the file backup script!

All you have to do now to get a backup of your entire webserver is just download the fullsite_backup.tar.gz file.

Using Godaddy SSL Cert on IIS 7 and IIS 6

GoDaddy called me today and said that they screwed up and allowed us to add an already existing domain (on some other clients certificate) to our certificate and that I needed to remove it. Ok. Done.

Godaddy: thanks, you have 24 hours to install your the newly generated certificate.

Thanks Godaddy, it’s Friday evening and my IT guys are out for the next 2 weeks. (It’s actually not that hard to do, but come on…)

You can just follow the online instructions to get the certificate up and running on IIS 7: http://help.godaddy.com/article/4801#Install_IIS7 So that got three of my sites back on using SSL.

Now when I went to update our IIS 6 websites, it wouldn’t work… So I called GoDaddy, maybe they’d give me some support.

Godaddy: Sorry sir, we don’t support how to export the SSL certificate from IIS 7 to IIS 6.

Me: Oh, that’s all I have to do? *hang up*

So I just went back into IIS 7, exported my certificate to a .pfx, then just imported it to IIS 6. Bam, all my IIS 6 websites were using SSL again 🙂