Skip to content

Instantly share code, notes, and snippets.

@cadic

cadic/move-wordpress.sql

Last active November 12, 2015 07:01
Show Gist options
  • Save cadic/cd72d40732f4f3e7231d to your computer and use it in GitHub Desktop.
Save cadic/cd72d40732f4f3e7231d to your computer and use it in GitHub Desktop.
Download ZIP
Database update when copying Wordpress site directly
Raw
move-wordpress.sql
UPDATE wp_options SET option_value = replace( option_value, '//old-address.com', '//new-address.com' );
UPDATE wp_posts SET post_content = replace( post_content, '//old-address.com', '//new-address.com' );
UPDATE wp_postmeta SET meta_value = replace( meta_value, '//old-address.com', '//new-address.com' );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment