Change Wordpress URL in Database (MySQL) - Revision history

Ddxfish at 15:57, 30 March 2020

2020-03-30T15:57:14Z

← Older revision		Revision as of 15:57, 30 March 2020
Line 2:		Line 2:

	==Notes about changing Wordpress URL==		==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~~		Backup your site first. Backup everything. Do this wrong and things will not work.


			Fill in your old and new URL and run this in phpmyadmin.
	<nowiki>		<nowiki>
	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_options SET option_value = replace(option_value, 'http://www.oldurl.com', 'http://www.newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';
Line 12:		Line 12:
	</nowiki>		</nowiki>

	Also pop this into your wp-config.php to override the Settings page:		Also pop this into your wp-config.php to override the Settings page URL
	<nowiki>		<nowiki>
	define( 'WP_HOME', 'http://example.com' );		define( 'WP_HOME', 'http://example.com' );
	define( 'WP_SITEURL', 'http://example.com' );		define( 'WP_SITEURL', 'http://example.com' );
	</nowiki>		</nowiki>


			Now you go into the phpmyadmin search tab and look for the old url. Don't replace it here, find where it is referencing in Wordpress and change in the Wordpress Dashboard.

	==External Links==		==External Links==

Ddxfish at 15:53, 30 March 2020

2020-03-30T15:53:23Z

← Older revision		Revision as of 15:53, 30 March 2020
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]]

Ddxfish at 15:16, 21 February 2016

2016-02-21T15:16:15Z

← Older revision		Revision as of 15:16, 21 February 2016
Line 5:		Line 5:


	<nowiki>		<nowiki>
	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_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 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_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');		UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl.com','http://www.newurl.com');
	</nowiki>		</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]]

Ddxfish at 15:04, 21 February 2016

2016-02-21T15:04:55Z

← Older revision		Revision as of 15:04, 21 February 2016
Line 1:		Line 1:
	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!		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

	<nowiki>
			<nowiki>
	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_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 guid = replace(guid, 'http://www.oldurl.com','http://www.newurl.com');

Ddxfish at 15:48, 20 February 2016

2016-02-20T15:48:01Z

← Older revision		Revision as of 15:48, 20 February 2016
Line 10:		Line 10:
	==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]]

Ddxfish at 15:46, 20 February 2016

2016-02-20T15:46:57Z

← Older revision		Revision as of 15:46, 20 February 2016
Line 2:		Line 2:


			<nowiki>
	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_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 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_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');		UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl.com','http://www.newurl.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]

Ddxfish: Created page with "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..."

2016-02-20T15:45:52Z

Created page with "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..."

New page

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!

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');

==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]