Archive for December, 2008


Backups in the cloud

Time to embrace the cloud. I previously had a script on my server performing a daily backup of the SQL databases (a mysqldump) that operate many of my sites. It didn’t make much sense to dump the backups on the same server; for the obvious reason that you’re unprotected against server problems, but also because it eats into the relatively more expensive hosting bandwidth and hard disk space provided from a typical VPS service.

RentACoder.com came to the rescue once again. For just $10, a new script that was created which carries out the same database dump, but now moves it to Amazon’s S3 platform. The service is ridiculously cheap – it’ll probably set me back around a buck a month.

Some brief instructions to get you started:

  • First, download the free Amazon A3 PHP class.
  • Grab my MYSQL Backup Dump on Amazon S3 Script
  • Get yourself a Amazon S3 account.
  • Edit the script to include your Amazon S3 credentials and database details.
  • Upload the files on to your server.
  • To test or run, hit the script from the browser or through SSH.
  • Optionally, add a task in Crontab to execute the script on a periodic basis.

Drop me an email if you require help, have feature suggestions or bug reports.

Update: I’ve added a buy-me-a-coffee donation link to this and other posts where I’ve provided something that can offer value to others. One donation so far!

 Tags: Internet   Published: 14th December '08

Introducing FixMyFloors.com

Feast your eyes on another oddball addition to Mander Enterprises. FixMyFloors.com offers an ‘information product’, a posh way of saying a paid-for PDF.

For a mere $9.95, I’ll tell you how one can remove the nasty residue left from cleaning products such as Orange Glo. However, you’ll first have to navigate through the multi-colour/font wonder that is the 1,500 word sales letter.

FixMyFloors.com

Traffic is purely organic and sales continue to trickle in. Interestingly, it has a tendency to pick up on Sunday’s – the holy day for DIY.

I’ve long fancied to operate one of these sites as it requires two essential tasks: buying as much traffic as possible that can provide a demonstrable ROI; and improving conversion rates through split-testing techniques I’ve previously talked about.

 Tags: Business, Internet, Introducing   Published: 5th December '08