Aston J

Posts Tagged ‘wordpress’

Ultimate MYSQL backup script – part one!

Posted on: July 27th, 2009 by AstonJ 12 Comments

There are lots of scripts out there that do a great job of backing up your MYSQL database – so why’s this one any different? And why does it deserve the ‘Ultimate’ label? Well, it

  • Is one of the few backup scripts that elegantly turns your site ‘off’ whilst carrying out a backup
  • Stores a copy of your backup on your server
  • Transfers another copy to a different server (offsite backup)
  • Keeps a month’s worth of backups
  • Sends you a nice report each day with detailed stats on how long each element took
  • Works with any site regardless of application, e.g. vBulletin, IPB, WordPress, Drupal, etc

The backup will take place every day, and simply overwrite the previous month’s backups, and as some months have 31 days, you’ll have that extra bit of contingency too. I’ve opted to create a guide on how to create this script rather than just give you the files and let you get on with it – it’ll help you understand what’s going on, and give you a warm fuzzy feeling inside!  (Not a hands-on type of person? Want someone to configure/set it all up for you? Scroll down to the end of this guide for more info!)

Part two will show you how to create a backup of your files too (e.g. image uploads) complementing this script perfectly, so stay tuned!