WordPress is an application which as gained much popularity due to its usefulness. But you may face a big problem, if you decide to move your WordPress blog to another URL or another server. Many of us would not want to again install WordPress on the new server, rearrange all the settings of the WordPress. It would be a very tedious task and we can lose all our important data. Off course, there is an option in WordPress to export the data to move our data, but most of the technical people like to avoid using this function. It can take a huge amount of time to go through this method if you have sizable data to be moved.
Another problem in importing the data is that it doesn’t copy the data created by any plug-in of WordPress. There can be some very important data created by our plug-ins, and many of us wouldn’t want to lose this data at any cost. So, if this option of import/export is not the best option to move the WordPress database, then what is the solution? The solution is WordPress cloning. Through the method of cloning, we can clone our entire data and plug into the second server. The best way to coy the database through cloning is by backing up all the data and configuration, and move to the new server. This way you can avoid all that rearrangement and reinstallation mess.
The steps to clone our WordPress database are through a series of steps, in which the sequence is very important. First of all you have to download the wp-db-backup plug-in from the internet. Then we have to upload this plug-in to our old server. After that, we have to activate the plug-in through the ‘Plugins’ menu in WordPress. Then we have to Go to the ‘Manage’-> ‘Backup’ menu. We can then select the tables. After that, we have to select the Backup option, so that we can download the gzip file through the internet. This file is consequently extracted to give a sql file. Then we have to open the sql with notepad or any other text editor. Then we have to search for the specific line in the sql file:INSERT INTO ‘wp_options’ VALUES (1, 0, ‘siteurl’.
Then, we look for something close to this format: INSERT INTO ‘wp_options’ VALUES (1, 0, ‘siteurl’, ‘your-old-url.com’, ‘yes’) Now e have to replace the old URL with the URL of our new server.
Then we have to search for another line: INSERT INTO ‘wp_options’ VALUES (39, 0, ‘home’,. Now we would see something like this:
INSERT INTO ‘wp_options’ VALUES (39, 0, ‘home’, ‘your-old-url.com’, ‘yes’) Once again, we have to replace the old URL with URL of our new server. Now, just save the changes and exit the program.
Now, you have to download the WordPress folder from the old server to your computer, by using a FTP program. After that, you have to log into PhpMyAdmin in the new server. You have to now create the new WordPress database, and also import the sql file to the database. The next step would be to alter the database configuration in the wp-config file in the WordPress folder. Now you can upload the WordPress folder to the new server.
You have now successfully cloned your WordPress database. You can now open the wp-login page in the newly created server, and login with your old username and password. You can enjoy all the old configuration settings.