Skip to content

Instantly share code, notes, and snippets.

@jamessom

jamessom/wordpress-to-live-site.md

Last active March 9, 2019 00:54
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jamessom/9945e372c67ebbb48c6d3132360d53c0 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jamessom/9945e372c67ebbb48c6d3132360d53c0 to your computer and use it in GitHub Desktop.
Download ZIP
Move wordpress to live site
Raw
wordpress-to-live-site.md

Change the Site URL

UPDATE `wp_options` SET `option_value` = 'http://newsite' WHERE `option_id` IN (1, 2);

Fix Images and Broken Links by Updating Paths

UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://localhost', 'www.yourlivesite.com/');
UPDATE wp_posts SET guid = REPLACE(guid, 'http://localhost', 'www.yourlivesite.com/');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment