Difference between revisions of "Change Wordpress URL in Database (MySQL)"

From ETCwiki
Jump to navigationJump to search
Line 11: Line 11:
 
  UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl.com','http://www.newurl.com');
 
  UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl.com','http://www.newurl.com');
 
  </nowiki>
 
  </nowiki>
 +
 +
Also pop this into your wp-config.php to override the Settings page:
 +
<nowiki>
 +
define( 'WP_HOME', 'http://example.com' );
 +
define( 'WP_SITEURL', 'http://example.com' );
 +
</nowiki>
 +
 
==External Links==
 
==External Links==
 
*[https://wpbeaches.com/updating-wordpress-mysql-database-after-moving-to-a-new-url/ Updating Wordpress MySQL Database After moving to a new url]
 
*[https://wpbeaches.com/updating-wordpress-mysql-database-after-moving-to-a-new-url/ Updating Wordpress MySQL Database After moving to a new url]
  
 
[[Category:Wordpress]]
 
[[Category:Wordpress]]

Revision as of 15:53, 30 March 2020

This code is to search and replace an old URL with a new URL inside your Wordpress SQL database. It would be easy to paste this code into phpmyadmin in the SQL tab to run all of these. Make sure you backup your database before you do anything!

Notes about changing Wordpress URL

  • If your new URL is a different length it can cause loss of widgets and other serialized data in the database


 UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl.com', 'http://www.newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';
 UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl.com','http://www.newurl.com');
 UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl.com', 'http://www.newurl.com');
 UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl.com','http://www.newurl.com');
 

Also pop this into your wp-config.php to override the Settings page:

 define( 'WP_HOME', 'http://example.com' );
 define( 'WP_SITEURL', 'http://example.com' );
 

External Links