This is a little tip for anyone that was using a test server before publishing there website to the world.
Before putting this blog up I was running it from my computer, so that I could muck about in the coding without everything going to hell. Once I had everything in some semblance of order and more or less working, I followed this helpful article from the WordPress Codex to transfer my site to the new server. I then encountered The Problem. All my images and links were going back to the database on my computer. So all the images where coming from http://localhost.zoddesign instead of www.zoddesign.com. and I don’t know if my humble iMac could handle the strain.  You see wordpress uses absolute paths instead of relative paths. I don’t know that much about php and databases so I’m sure there’s a reason for it

An absolute path is like receving a friends address, city, province, and postal code.
while a relative path is like saying it’s at the corner of such and such road.

Now you can go into each page fixing every link after link then checking them over and over again or the Zod way.
I should point out by the time I finally found how to do this I could have fixed all the links manualy but now I know how to do it and knowing is half the battle.

Step 1: first go into your cPanel and look for phpMyAdmin. Once you find it give it a click to open it.
Step 2: Now on the left hand side there will be a list of databases click on the wordpress database.
Step 3: At the top of the page will be a button called SQL give it a tap.
now the good part
Step 4: In the text box below type in the following
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-example.com', 'http://www.new-example.com') WHERE option_name = 'home' OR option_name = 'siteurl';
if this didn’t do anything then congratulations you setup wordpress correctly on the new server.
Step 5: Now to fix the posts and pages links with the following command
UPDATE wp_posts SET guid = replace(guid, 'http://www.old-example.com','http://www.new-example.com');
Step 6: and finaly any internal links linking to your site
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');

And there you have it

Keep Reading