PLANET3RRY Aspergian with Running Tendancies

Places To Find Me

Current Contest

The next Guess My Time, Win Crap contest will be for the Breakthrough Ribbon Run 5k in April. Details closer to race date.

Menu of Memories

Calender

March 2010
M T W T F S S
« Feb «-»  
1234567
891011121314
15161718192021
22232425262728
293031  

Terry’s Running Corner

TRAINING
2010 RACE SCHEDULE 02/28 Whitestone 30k (Paint Rock, TN)
04/17 Breakthrough Ribbon Run 5k (Knoxville, TN)
04/27 Rittenhouse Half Marathon (Harriman, TN)
05/01 Run for the Deaf (Knoxville, TN)
05/29 Expo 10k (Knoxville, TN)
07/03 Fireball 5k Classic (Knoxville, TN)
08/14 Scholar's Run 5k (Knoxville, TN)
09/25 Big South Fork 17.5mi Trail Run (Knoxville, TN)
11/21 Flying Monkey Marathon (Nashville, TN)
12/05 Reindeer Run 5k

  • Jan
    29

    By Hand, The Technical Way

    Filed under: Life In General; Tagged as:

    So I thought that the Upgrade to my blog would be easy… well, it was except that I had an error saying that I couldn’t upgrade to WordPress 2.9.1 because MySQL db was something like 4.0.69 and it needed to be like 4.1.3.

    No Problem… Export old db, Make NEW MySQL database 5.something, Import and I would be good to go.
    Except that whole IMPORT thing didn’t work… or at least I didn’t know what check boxes to check/uncheck. Of course needing the internet, this was something I wanted to do here at work, since it was already in the middle of upgrading and I didn’t want to leave all of my readers in suspense on when Planet3rry.com was going to be back online.

    So, I did it the old fashion way… by hand. Except in the world of computers… that is the Ol’ Cut N’ Paste. So I opened two windows of phpMYAdmin, one of the old WordPress database and one of the new database. Then take each table from the old database and Export it to SQL code, Go to the new database and run the SQL code which creates the table (and thankfully) and populates the data. I had 29 Tables…

    Finally it’s done, the upgrade seem to have took. I don’t have time to fix/upgrade my plugins, because while all of this is going on at my desk at work. The GREAT BLIZZARD OF FRIDAY 3pm is happening right now. Of course, you may think that I am CRAZY for doing all this in the FREAKIN’ BLIZZARD, but this is how I look at it…

    Everyone else scattered earlier… they’ll find all the slick spots before I do… and just by the sheer number of people leaving there will be less idiots out on the road when I make it home. Well, according to some, there will be at least one… I do have a contingency plan if I can’t get the car home… I have my running clothes with me!

    1 Comment

One Response to “By Hand, The Technical Way”

  1. Ah, the database problem. I spent 4 hours at my database guru’s house working on mine. I have 6 databases that had to be upgraded for the same reason. The problem was one particular table that was killing us. Once we figured out which one it was it was easy to export everything but that one and then manually copy/paste the one problematic table. I know I should have written it down at the time. But that has been 3 weeks ago and I am clueless now as to what the steps were.

    Glad to see you up and running though.

Leave a Reply