A Simplified Approach To Backing Up WordPress Database Tables – wordpress database backup

WordPress has become the top choice for bloggers around the world due to its simple and easy to install procedure, as well as the powerful core features that advanced users can make use of. Many bloggers maintain multiple blogs and it can sometimes be a hassle if you are looking to make a duplicate or clone your WordPress blog. To clone WordPress you need to be an advanced user since you will have to make use of some server voodoo, but it is not as complex as this is making it sound. In fact, this article will offer a step by step procedure on how to clone WordPress blogs.

It can be easy to mistake the export/import function under the ‘Manage’ menu as a means of cloning your blog. That option is for migrating posts and comments to a new blog. However, it can be a hassle if you are moving a huge database. Additionally, it does not migrate plugins, themes and other customizations and add-ons you may have installed. The best way to move your blog is to back up your database tables. This will include the tables created by the plugins, so all your customizations will be ported over as well.

There are multiple ways of backing up your database. The easiest way is to use PHPMyAdmin to select the database and create a dump. Another way is to download a plugin called WP DB Backup. You have to install it in your WordPress installation and run the plugin. It will make a gzip file containing your database with all the required tables.

Extract the gzip file to get a SQL file. Use a text editor like Notepad to open the file and search for the line:

INSERT INTO `wp_options` VALUES (1, 0, ‘siteurl’, ‘ OLD URL’, ‘yes’)

All you have to do is replace your old blog URL with that of your new one. You should also search for:

INSERT INTO `wp_options` VALUES (39, 0, ‘home’, ‘ OLD URL’, ‘yes’)

As you have done before, replace old URL with your new URL. That is the hard part done. Now, all you have to do is download the whole WordPress folder from your old server and upload it to your new one keeping the folder structure intact. Then login to PHPMyAdmin again and import the SQL file to the database. Finally, change the database configuration in the wp-config file in your WordPress folder to match your new server.

That is all there is to it. You can now login with your old credentials in to the cloned WordPress installation. All plugins, themes, posts, comments and other add-ons will all be there.

You might, however, run into problems importing the SQL file if it is too large. In that case, all you have to do is use a script called BigDump to import the file. It breaks the SQL file into manageable chunks and imports it sequentially, thus avoiding errors.

Now you know how to clone WordPress blogs. It is a very easy task, though it is not for novices. So, the next time you clone WordPress, make sure to follow all the steps for an error-free experience.