Manual change of URL in WordPress
- siwy
- paź, 18, 2018
- Useful commands, WordPress
- No Comments
First login to database.
Check what is the current URL:
select * from wp_options where option_name = 'home' OR option_name = 'siteurl';
SQL to change URL:
UPDATE wp_options SET option_value = replace(option_value, 'https://www.old.pl', 'http://new.home.pl') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'https://www.old.pl','http://new.home.pl');
UPDATE wp_posts SET post_content = replace(post_content, 'https://www.old.pl', 'http://new.home.pl');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://www.old.pl','http://new.home.pl');
In this case, I change https url to http. Remember to use correct protocol.