Skip to content

Instantly share code, notes, and snippets.

@elicus

elicus/WordPress sql query to change path or domain name or a website

Last active May 7, 2020 10:03
Show Gist options
  • Save elicus/0c3884e91a05bb9675e2dd364d65cba1 to your computer and use it in GitHub Desktop.
Save elicus/0c3884e91a05bb9675e2dd364d65cba1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
WordPress sql query to change path or domain name or a website
UPDATE wp_options SET option_value = REPLACE (option_value, 'http://www.YOUR-OLD-DOMAIN.com', 'http://www.YOUR-NEW-DOMAIN.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = REPLACE (guid, 'http://www.YOUR-OLD-DOMAIN.com','http://www.YOUR-NEW-DOMAIN.com');
UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://www.YOUR-OLD-DOMAIN.com','http://www.YOUR-NEW-DOMAIN.com');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment