Move WordPress to a New Domain Name

A problem encountered when you want to change the URL of the blog: How to move with ease her WordPress blog domain name to another?

It is move WordPress Blog

Sometimes you need to change the URL of the area or simply to change to make it more efficient and to better reflect the focus of the blog.

If you decide to change the URL location of your WordPress blog because of a change of domain name (http://www.old-domaine.com to http://www.new-domaine.com) or why not in a subdirectory (http://www.domaine.com to http://www.domaine.com/blog), there are some simple steps to ensure a proper migration and not break any links.

Attention, this article does not address the movement of a WordPress blog from one server to another hosting or hosting...

Who Must Be Changed Or Not

Before anything else, and in the preamble, do not forget to perform a full backup of your files and your database.

The tricky when moving a WordPress blog to another location part, lies in the fact that WordPress uses absolute links instead of relative link when stores certain settings in your database. In the articles and pages of your blog itself, there will inevitably be absolute links (eg http://www.old-domaine.com/myarticle)
All values of the database will be changed when migrating your WordPress. This article will show you which fields of the database to be replaced and what SQL commands to use.

Once your entire blog has been moved, the first thing to do is to inform WordPress change and give it a new location (the wp-config.php file and .Htaccess should cause no change). This value can be changed from WP admin in general options, but if you cannot access the URL of the old blog, you should change this value directly from the MySQL database.

Procedures and SQL Queries To Use

To execute SQL queries, log the MySQL database that houses WordPress tables via phpMyAdmin or connect to the server database and run the MySQL client as root.
To update options for the location of the new blog, use the following SQL command:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.ancien-domain.com', 'http://www.nouveau-domaine.com') WHERE option_name = 'home' OR option_name = 'siteurl';

After that, you will need to repair the URL of your articles and pages, these URL values are stored as absolute URLs, and therefore they need to be changed, make the change with the following SQL query:

UPDATE wp_posts SET guid = replace(guid, 'http://www.ancien-domaine.com','http://www.nouveau-domaine.com');

If you link internally within articles or pages with absolute URLs, these links are now pointing to the wrong URL as you moved. Use the following SQL command to fix all internal links articles and pages:

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.ancien-domaine.com', 'http://www.nouveau-domaine.com');

And now, it's already over!
Now browse your blog to make sure everything works properly. You will also need to reconnect to the WP administration; in fact, your authentication cookie has become invalid due to the change of URL.

Wednesday, October 2, 2013