WordPress Change the domain name after the link error resolution method

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 ');