3 Days in 1.340952 seconds.
Revised: April 29, 2007When you sit down in front of the computer and work hard for three days on a project, you don’t tend to expect it to accumulate to just pressing a button and never using the proceeds of your work again. However that is exactly what happened to me the past three days while trying to clean up this blogs database. There was too much stuff in there that I had picked up from “dirty” plugins and somehow that extra baggage was causing the administration area of my Wordpress install to break, it had to have been the database as wiped the previous installs files and then re-installed Wordpress using the same old database.
I wrote a custom script in php to copy select bits of my old Wordpress database and after filtering out and changing select bits inserting them into the new Wordpress install. It took three attempts due to me forgetting certain bits and general bugs however after a little bit of playing I managed to get the whole thing to work, over a thousand MySQL queries in a second later and everything is done. I now have a nice clean install with all my old posts and comments, new clean plugins and a beautiful hand made and coded design. What more could a blogger ask for?
