Migration help

After months of painstakingly getting everything right on my new Geodirectory site I decdied yesterday was the day to make the switchover with my old Geotheme website.

It seemed straight-forward enough; The files were already in place, the database in place. So it should’ve been simpler than migrating to a completely different server.
…. after a bit of research I figured the steps I needed to take were:-
1) On the database update the site references, along the lines of…

UPDATE wp_options SET option_value = REPLACE(option_value, 'ORIGINAL_URL', 'NEW_URL');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'ORIGINAL_URL', 'NEW_URL');
UPDATE wp_posts SET guid = REPLACE(guid, 'ORIGINAL_URL', 'NEW_URL');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'ORIGINAL_URL', 'NEW_URL');

2) On the server change the file hosting location from ‘old_site’ to ‘new_site’ so that all the new files were in place

Yikes! That was a total *bleep* up!

I could access the site, even view the blog but none of my places or other CPTS were accessible (everything was an “epic 404”), all the widgets had disappeared, GD Framework configuration gone, etc etc.

I played around for a while trying to find a solution but with no joy. My last attempt to fix it was to point the development site to a different hosting location in case that somehow was the problem (daft, but at 2am in the morning it seemed plausible….)

As it was getting late I switched back and with a great sigh of relief at least my old Geotheme site seems to be okay. However, when I’ve tried to recover my development site I can’t get my places back.

After several hours wasted today trying to figure what’s gone wrong I’ve restored my development site to a slightly outdated version but at least it’s there.

Obviously I didn’t do something right on my first migration attempt, adn don’t want to screw it up again, so would really appreciate some pointers on how to correctly migrate.