WordPress site replacement domain name of some of the operating methods

In the group to see a lot of friends asked, wordpress to change the domain name to do so? Background settings – routine changes in the domain name, the station can not open, and this is why? Do this
In fact, wordpress for domain name to the database to operate, first of all, to analyze the domain name for several common situations.

One, for space for domain name
1, if it is the above problem, the package backup the old space ftp all the files, into the old station database phpmyadmin export your site database sql file;
2, will be the backup of the ftp all files uploaded to the new space FTP, the backup of the sql uploaded to the new space in the database phpmyadmin;
3, open the new space ftp site root directory to find wp-config.php file, edit it (php file do not use txt to edit), edit the configuration of the new database connection information;
4, to the new space database phpmyadmin Lane, do sql batch for domain name processing (see the following tutorial two)

Second, only for domain name, no room for change
Open the new space of phpmyadmin (database control panel)
And then select the new database name, click, enter wp_ at the beginning of the table is greater than or equal to 11, and then select the sql in the tab, as shown in Figure:

Then is the order for the order of sql batch processing:


  • UPDATE wp_options SET option_value = replace( option_value, ‘http://www.old.com’, ‘http://www.new.com’ ) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
  • UPDATE wp_posts SET post_content = replace( post_content, ‘http://www.old.com’, ‘http://www.new.com’ ) ;
  • UPDATE wp_posts SET guid = replace( guid, ‘http://www.old.com’, ‘http://www.new.com’ ) ;

old on behalf of the old domain name, new on behalf of the new domain name, the above implementation of the statement will be modified to your own, and then click on the implementation can be!
To this step, the basic OK OK. The The Of course, for the way the domain name will encounter a variety of problems, there can be a problem to join our technical group to help Kazakhstan!