Error resolving replacement domain name
Note: The symbols for all of the following SQL statements must be in English half-width
Question: After changing the domain name, the website front desk opens the blank, backstage cannot log in;
WORKAROUND: Use the database management software phpMyAdmin to change the value of the Option_value field in Wp_options SiteURL and home.
SQL statement:
The code is as follows |
Copy Code |
UPDATE wp_options SET option_value = REPLACE (option_value, ' original domain name ', ' new domain name ');
|
Problem: After changing the domain name, the internal link in the article and the address of the attachment is wrong;
Workaround: Also use phpMyAdmin to change the value of the Post_content field in Wp_posts.
SQL statement:
The code is as follows |
Copy Code |
UPDATE wp_posts SET post_content = replace (post_content, ' original domain name ', ' new domain name ');
|
Problem: After changing the domain name, the article Permanent link address error;
Workaround: Also use phpMyAdmin to change the value of the GUID field in Wp_posts.
SQL statement:
The code is as follows |
Copy Code |
UPDATE wp_posts SET GUID = replace (GUID, ' original domain name ', ' new domain name '); |
Question: After changing the domain name, the author comments the website address error;
Workaround: Also use phpMyAdmin to change the value of the Comment_author_url field in Wp_comments.
SQL statement:
code is as follows |
copy code |
UPDATE Wp_ comments set comment_author_url = replace (comment_author_url, ' original domain name ', ' new domain name '); |