How To Transfer A WordPress Database To A New Hosting Account

No doubt you would already know of the frustration associated with how to migrate WordPress databases. Truth be told, its a relatively simple process that almost anyone can do, permitting of course that you are careful, and that you have a basic understanding of the process. The process that I will teach today can be used with just about any hosting account to, just so long as you have access to cPanel or your respective administration panel, plus have the right permission to create new databases, plus assign new users to these databases.

First things first, you will need to access phpMYadmin. Details on how to access this within your hosting accounts administration panel should be easy to source out through your hosting provider, or your welcome email that you received when you first signed up. For those of you who are not all that fluent when it comes to hosting accounts, phpMYadmin is the area in your hosting account where you can modify, import and export databases. In all essence, a highly sensitive part of your hosting account, so please be sure to follow my instructions correctly today.

In phpMYadmin, select the database that your WordPress blog uses. If you are unfamiliar with which database this is, just take a look in your WP-config file, as this will contain the right details. Once you know what database you are using, select it, and click on the export button. In here, you can simply download the database as a plain sql file to your computer.

Next, enter the administration panel for the hosting account that you are transferring your blog to, and create a new database and user, plus assign the user to the new database with full permissions. Again, instructions on how to do this will vary between hosting accounts, but will be easy to source out through your providers support documentation.

Next, enter your phpMYadmin area and select the newly created database. As you will be able to see, the database has no tables and no data contained, which is completely normal as it is new. All that you will need to do at this point is import the original database into the new one by clicking the import button, browsing to the original sql file that you downloaded, and upload it. Once this has completed, it is very well worth your while to navigate into the database, and just check that data has actually been imported properly.

So, that is how to migrate WordPress databases. Sure, it is a little complicated, and whilst there are many other easier methods that utilize software applications out there, this is a basic overview of how you can get the job done fairly easy. As I mentioned earlier, this is somewhat of a sensitive process that needs to be followed word for word, otherwise you may risk doing damage to your database, so please be careful when doing this. If you are not confident in your ability, there are other methods that you can follow, but if you are confident, then give this process some practice.

Discover the easy way to migrate WordPress today, both the slow manual way, and the easy and secure way.