Posts Tagged ‘mysql’
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!
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!
clean lion install for ruby dev