Moving WordPress: 1. Replacing WordPress’ base URL path. 2. Update the GUID that controls WordPress’ translating paths and post locations. 3. Update the URL paths in the content. 4. Update the URLs in the meta data of posts, such as attachments.

moving_wordpress

UPDATE wp_options SET option_value = replace(option_value, 'http://localhost:8888/wordpress', 'http://www.YOUR_SITE_URL.com') WHERE option_name = 'home' OR option_name = 'siteurl';

moving_wordpress_2

UPDATE wp_posts SET guid = REPLACE (guid, 'http://localhost:8888/wordpress', 'http://www.YOUR_SITE_URL.com');

moving_wordpress_3

UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://localhost:8888/wordpress', 'http://www.YOUR_SITE_URL.com');

moving_wordpress_4

UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://localhost:8888/wordpress','http://www.YOUR_SITE_URL.com');