While during a wordpress migration, here i need to change the domain name. Currently, after WP migration all the links are pointing to the old domain name. We can solve this my updating a field in mysql DB.
Changing WordPress Home URL and Site URL via MySQL database.
Login to Mysql
use Database_name;
SELECT * FROM wp_options WHERE option_name = 'home';
This will show the current site url
UPDATE wp_options SET option_value="http://newdomain.com" WHERE option_name = "home";
Verify whether the change got reflected
SELECT * FROM wp_options WHERE option_name = 'siteurl';
Changing WordPress Home URL and Site URL via MySQL database.
Login to Mysql
use Database_name;
SELECT * FROM wp_options WHERE option_name = 'home';
This will show the current site url
UPDATE wp_options SET option_value="http://newdomain.com" WHERE option_name = "home";
Verify whether the change got reflected
SELECT * FROM wp_options WHERE option_name = 'siteurl';
No comments:
Post a Comment