Moving my wordpress weblog

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!