Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@jamiehs

jamiehs/update-domain-name-2.sql

Created March 19, 2014 17:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save jamiehs/9647105 to your computer and use it in GitHub Desktop.
Save jamiehs/9647105 to your computer and use it in GitHub Desktop.
Download ZIP
Simple version of MySQL find and replace for WOrdPress database migration.
Raw
update-domain-name-2.sql
# Update wp_options table
UPDATE wp_options SET option_value = REPLACE(option_value,'example.com','example.dev');
# Update wp_posts table
UPDATE wp_posts SET guid = REPLACE(guid,'example.com','example.dev');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment