Смена адреса сайта Wordpress
Чтобы поменять URL на сайте WordPress, выполните команды sql
UPDATE wp_options SET option_value='https://new_url/' where option_name='siteurl';
UPDATE wp_options SET option_value='https://new_url/' where option_name='home';
UPDATE wp_posts SET guid = REPLACE(guid, 'https://old_url', 'https://new_url') WHERE guid LIKE 'https://old_url%';
UPDATE wp_posts SET pinged = REPLACE(post_content, 'https://old_url', 'https://new_url') WHERE post_content LIKE '%https://old_url%';
UPDATE wp_posts SET pinged = REPLACE(pinged, 'https://old_url', 'https://new_url') WHERE pinged LIKE '%https://old_url%';
UPDATE wp_options SET option_value=REPLACE(option_value, 'https://old_url', 'https://new_url') WHERE option_value LIKE '%https://old_url%';
UPDATE wp_options SET option_value=REPLACE(option_value, 'http://old_url', 'https://new_url') WHERE option_value LIKE '%http://old_url%';
UPDATE wp_options SET option_value=REPLACE(option_value, 'old_url', 'new_url') WHERE option_value LIKE '%old_url%';