Manual change of URL in WordPress

• No Comments
• paź, 18, 2018
• siwy
• Useful commands, 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 […]