Big thanks to Ryan Carter who wrote up a nice method for moving ones wordpress weblog. My first was to upload the tables and copy all the data into the wp_ tables but that did not work. My problem was that on my previous host I had the tables prefixed as tom_ and the default install on my new host uses wp_. So in order to get the method outlined to work I edited the downloaded sql by changing all the tom_ to wp_, this was all the tables and a few rows in the wp_usermeta and wp_options tables. But as you can see now, everything is working now, YEAH!
Heard this quote on the Writers Almanac today:
There have never in history been so many opportunities to so many things that aren’t worth doing. William Gaddis
And you know I don’t think he was talking about the world wide web either, I suppose he would have given up and gone off to live as hermit if could see how it now.