Aston J

Archive for July, 2009

How to move your site to a new server

Posted on: July 28th, 2009 by AstonJ No Comments

In this guide, we’ll look at moving a MYSQL based website to a new server. For the purpose of this guide, this step-by-step is for a vBulletin based site, but the principles are the same no matter what type of application your site is using (eg Drupal, WordPress, etc).


  • Transfer our website files from the old server to the new server
  • Make a copy of our database
  • Transfer the database to the new server
  • Set the database up to work on the new server
  • Press the on switch!


How to install XCache

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

XCache is one of the most respected php cachers around, so here’s a little how to guide that I wrote up as a reference for myself a while back. Hope you find it useful…

  • Ssh telnet into your server as root user
  • Grab XCache by typing:
cd /usr/local/src

Wait for package to download


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!