Manual change of URL in WordPress

Manual change of URL in WordPress

 

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.

Dodaj komentarz

Twój adres email nie zostanie opublikowany.

This site uses Akismet to reduce spam. Learn how your comment data is processed.