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.

Witryna wykorzystuje Akismet, aby ograniczyć spam. Dowiedz się więcej jak przetwarzane są dane komentarzy.