Change URL of wordpress site Using MySQL

Change URL of wordpress site Using MySQL

Change URL of wordpress site Using MySQL

Using This following code your can change URL of wordpress site. This method is recommended when you moving site from one url in to another.

Example: Localhost to live production server migration.

UPDATE wp_options SET option_value = replace(option_value, 'http://old.com', 'http://new.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://old.com','http://new.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://old.com', 'http://new.com');
UChange URL of wordpress site Using MySQLPDATE wp_postmeta SET meta_value = replace(meta_value,'http://old.com','http://new.com');

Change URL of wordpress site Using MySQL