Doh! Sorry about that everyone. Caspian IT was offline for a bit just now – you won’t believe what happened, in fact I’m not sure I believe it, which is why I’m writing this post.
As an avid reader of universetoday.com I’ve been catching up on their latest news. This is the 40th anniversary of the Apollo 13 mission to the Moon. Heralded as a ‘successful failure’ by NASA the crew did indeed return home safely after a 7 day tip that so could have easily ended in tragedy.
Anyway, it just so happens that I was watching a re-run of Apollo 13 when disaster struck! I was running a file-duplicate remover on my server and in a rather too Cavalier fashion I click my way through a few results that I really should have been paying closer attention to.
Anyway, I’m glad to report that I’ve got everything back up and running exactly as it should be and without any data loss.
Whilst I’m at it, me being a technical blogger n’ all I’ll briefly explain how – after a disaster – I was able to get everything back to normal.
WordPress disaster recovery.
1. I’m using MySQL (as we all are when hosting WordPress) I went in to MySQL Administrator and took a complete copy of the database.
2. I then deleted the Schema (deleting the database completely). I then created a new fresh and empty database of the same name
3. I then copied the latest version of WordPress (2.9.2) over original thus replacing any missing files that might have been remved by the file-duplicate remover program I’d just run on my server.
4. I then copies ALL of the plugins I had been using in to the plugins folder
5. This now meant that I could visit my home page and was presented with the WordPress set-up screen as one would expect – I entered the details accordingly.
6. I then entered Worpress’ admin, went to the plugins section and re-activated all the plugins I had been using – This step is absolutely necessary and is the key to gaining a sucessful recovery!
7. I then went back to MySQL, read in, and executed the .sql script I’d backed up in step 1.
8. That’s it, there is no step 8. Everything was back up and running.
9. There might be a step nine though which is – Remember the next time you site round to watch Apollo 13 – make sure you’re in a safe environment out of harms was and not considering doing anything radical or blaisé.
WordPress, IIS7 URL rewrite.
OK, no need to panic whatsoever, WordPress 2.8 and above have AUTOMATIC configuration for IIS7 built in! WordPress will create the web.config file for you – it will look something like this: