How to transfer posts on different WordPress website?

airplane_in_the_sky

It may happen that in some time we will want to transfer all our posts into different website, different WordPress domain. In this article we will tell you exactly what and how to do to enjoy successful result of this process.

THE BEGINNING

First of all, we need to remember that it is crucial to do the same what we had to do while transferring WP onto different server – copy all catalogues and files from the old domain and export database. After completing those activities we may start destined actions.

PREPARING THE NEW DOMAIN

Now we have to put into our new domain all files and catalogues copied from the old domain. After that all you have to do is import database.

PHPMYADMIN

After opening phpmyadmin we need to choose given database, entering the SQL and type down three queries:

UPDATE wp_options SET option_value = replace(option_value, ‚http://www.olddomain.com’, ‚http://www.newdomain.pl’) WHERE option_name = ‚home’ OR option_name = ‚siteurl’;

  • After that we click accomplish and type down:

UPDATE wp_posts SET guid = replace(guid, ‚http://www.olddomain.com’,’http://www.newdomain.com’);

  • The last but not least command is:

UPDATE wp_posts SET post_content = replace(post_content, ‚http://www.olddomain.com’, ‚http://www.newdomain.com’);

 
These are activities and actions you need to take to successfully transfer your posts into new, different domain. This is an easy and quick way of changing your WordPress.