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 e-mail nie zostanie opublikowany. Wymagane pola są oznaczone *

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