Lots of Fun!

Well in the process of updating the site i had a number of issues. i was getting internal server errors (500) and Media Temple told me it was because i am using WordPress 2.7 Beta. Except its working fine on the same server on under a different domain.

I thought maybe cleaning up the chunky 30mb SQL file might help. I began by backing up my Database, and then copying my wp-content/plugins folder. i proceeded to uninstall any unused plugins and deactivating any unused plugins. once that was complete i didn’t notice any gains.

Since my SQL Export was 30 mb, i began to compare my development install database against my live database to clear up the SQL. Simple enough, deleted a few tables here a couple rows there. I made sure to reload the page to make sure everything was in order. I started to comfortable in my deleting and accidentally deleted my Category table. Oh No i thought. Then i remembered i made a back up rite before i started my cleaning. So i went into the SQL section of PHPMyAdmin but when i pasted the section of MySQL in the window i was prompted with an error. Humm. What now. SO i decide to go balls out and just wipe out the whole Database. It was a tense moment when i okayed the deletion of over 3 years worth of blog posts. But hey, thats why i backed up the DB! I close my eyes and click OK.

I go back to PHPMyAdmin and head on over to the import tab select my file luckily the zip is only 3.2mb, browse to it, upload wait a bit, and there we go, and Internal Server Error (500), so i attempt to see if anything happened, see a few tables were created so i delete the last incomplete table and start over. Now i get an error, things are not looking good.

What now? well i head over to my Dev install and luckily i had imported all data by using the WordPress import/Export Tool. FYI only a 3mb XML file.

Were does this leave me? well all content, comments, images, Categories, and Links were imported, there were only two small snags. Post Tags came across as numbers, neat but not usable, and link categories were nill, so i have to re-tag posts and re-categorize my links and then all is well.

Oh yes, My WordPress install works fine now.