Failure is the Key to Success

Like a lot of other people, I came across a problem when trying to automatically upgrade my blogs to WordPress 2.9. My web host is 1and1 and the database that I had my blog in was a MySQL 4 database, specifically 4.0.27. The problem is, WordPress 2.9 needs 4.1.2 or 5 (I know its in the requirements, but I didn’t read them I just hit ‘upgrade automatically’). After finding this post by Don Campbell, What I Learned Upgrading to WordPress 2.9, I knew my best option was to change my database to a MySQL 5 one. Unfortunately, although I have two databases available to me on my hosting package, but I was using both and both were MySQL 4.

I checked all the applications I had using the database (PhpGedView, Gallery and phpBB) to confirm they were all able to work with MySQL 5, and found they were. That’s a good start! I already knew WordPress was OK, so I set about exporting the tables for each of my blogs and applications to file ready to import into another database. The tables for Firestats were the largest and a couple of them had to be exported individually, otherwise phpAdmin choked.

Continue reading » Upgrading to WordPress 2.9

Tags:1 and 1,FireStats,MySQL,upgrading Wordpress,Wordpress 2.9

• Snowing in Dunstable and MK, took 1.75 hr to drive back from shopping in MK. Light but constant #uksnow 5/10 LU6 #
• Tried to upgrade test blog to WordPress 2.9. Needs MySQL 4.1.2; my hosting isn’t that version yet. Can take to 5 but check all apps work 1st #
• Ford has agreed the terms of the sale of its Swedish business, Volvo Cars, to China’s Geely. http://bit.ly/7hAd6X #
• Emily Smith on BBC One Scotland’s ‘Hogmanay Live’ on Dec 31st 23:45 – 00:45 http://bit.ly/7ApZql (VirginMedia channel 862) #
• Just finished playing scrabble with the kids. I lost! I had a run of only vowels and nowhere to put them. Out of practice #
• Google are giving £12.4 million ($20 million) to charity this Christmas. http://bit.ly/8XqnwB No matter what you think of them, that’s great #
• On second thoughts, picking up the coffee jar by the lid and finding the lid only partially on wasn’t such a good idea. Enough left for cup. #
• Merry Christmas everyone #
• Despite not mentioning it before, my daughter loves her GoGo Hampster Pipspeak. It was evidently the one she wanted out of all of them. #
• The Nintendo Wii was a great hit. Will be playing it later today. #

Powered by Twitter Tools

• Back from the Governors' Merit Assembly this morning. The recorder group that I run on a Friday played really well. Their effort payed off. #
• It was frosty out this morning when I looked at 6:00am. Sometime since it has snowed in Dunstable, only a light dusting. #
• @gvvaughan Didn't last long then it melted. Just cold, 0C now. Maybe due some sleet and snow later. Thu – Sat could be more, brrr in reply to gvvaughan #
• Snowing again in Dunstable, maybe its sleet. Whichever, its cold out there! #
• Watching the cars wheel spinning on road next to mine #
• No internet. Virginmedia will fix by 10am tommorow. #
• Internet came back this morning about 1am #
• #uksnow settled in Dunstable this morning, about 2 inches from the look. No reports of the schools closed, but it is the last day anyway #
• Watling Lower, Ashton Middle and Manshead Upper Schools in Dunstable closed for the day due to #uksnow. #
• Journey from Dunstable to Milton Keynes on A5 was fine this morning. No impact from #uksnow #
• Spammers have found an album on my photo gallery that they have delugued with spam. It filled my hosted database and killed my blogs. Aaargh #
• Shopping in MK. Quiet for last weekend before Xmas #
• Can't believe how stupid some drivers are. 'I can't get traction – let's put my foot to the floor and spin the wheels even more' #uksnow #
• Traffic southbound into Dunstable very slow. 30 minutes from Tilsworth to the fire station. #

Powered by Twitter Tools

• Did a spot of shopping in Dunstable this afternoon. Jericco Designs, the jewellery shop on West St. http://bit.ly/8aK0hd is worth a visit #
• Oops, actually the jewellery shop on West St, Dunstable is To Have & To Hold, their website is Jericco Designs http://bit.ly/8aK0hd #

Powered by Twitter Tools

• This year's Music Centre Christmas meal and singsong on Sat. has just been cancelled ;( There weren't enough of us that could make the date. #
• RT @makedaisychains: Katharine Blake & new recorder..! http://bit.ly/6XLh5T #
• RT @DLDUNSTABLEDIE: Christmas Tree Carols and Torchlight procession at The Square by Methodist Church, Dunstable Friday.http://bit.ly/67EzPn #
• Finished wrapping son's birthday presents and now eating limited edition Mars Dark. I love dark chocolate. #
• End of term concert at Dunstable Music Centre tomorrow. 9:30-12:30 at Manshead School. #
• Amazon UK canceled my order for Raymond E Feist's new book 'At the Gates of Darkness'. Supplier said it was discontinued! Re-pre-ordered it #
• Check out 'At the Gates of Darkness (Demonwar Saga 2)' by Raymond E. Feist (Hardcover… http://bit.ly/7gG0qI #
• Back from the Christmas Tree Carols in Dunstable. It rained, but was a good time. It took Basil Brush 3 attempts to turn the tree lights on. #
• Gave in to temptation. Another dark chocolate Mars bar. Mmmmmm #chocolate #
• Off to the Dunstable Music Centre end of term concert at Manshead School. Starts 9:30 this morning. I hope my recorder practice was enough. #
• Dunstable Music Centre concert went really well. There was a great turn-out, had to put out extra chairs at the interval. #

Powered by Twitter Tools

The Sunday following our trip to Classical Spectacular, we headed up to The Stables in Wavendon, Milton Keynes to see Emily Smith in concert.

I hadn’t really heard of Emily Smith before September. The brochure from The Stables arrived and I was looking through it to see who was on and the write up caught my eye. I typed in the link to her website and then listened to the tracks on the jukebox, I was hooked. We ordered her latest album ‘Too Long Away‘ and then became annoyed as it looked like the date she was playing was the same as the Classical Spectacular, typical! It was a couple of weeks before I realised my mistake, they were Saturday and Sunday, and ordered tickets for The Stables. She was playing Stage 2 at The Stables, which was going to be a new experience for us.

Continue reading » Emily Smith and Jamie McClennan

Tags:Emily Smith,Jamie McClennan