Blogging Tips Today
Spread the Word!

How to Move Your WordPress Database to Another Server

Hi, in my previous post titled – How to Move Your WordPress Blog to Another Host Using SSHI showed you how to move your WP blog files to another host server using SSH. SSH file transfer is an easy, fast and efficient way to move your blog from one host to another without using your DATA Bandwidth but unfortunately, SSH File transfer does not support moving of website databases across different servers, this means you have to move your WP blog database manually with SSH does the files transfer automatically.

By now, I assume you might have moved your blog files by following my first tutorial; your blog files is resting on your new server and all that is left is to move the database and complete your transfer process.

Without much ado, let’s see how to transfer your WordPress database to another server or host. 

Step 1 – Login to Your Cpanel

The first thing you need to do in other to transfer your blog database to a new server is to login to your blog Cpanel. The Cpanel is where you have access to all your website files and modify things on your blog.

Usually, you should be able to access your by going to your-domain.com/cpanel or cpanel.your-domain.com depending on your webhost settings.

cpanel login

Once you get to your Cpanel login page, enter your login details and sign in to your Cpanel dashboard

Step 2 – Locating Your Database

Once you get into your Cpanel Admin area, the next thing is for you to locate your database files. You can do this by scrolling down your Cpanel dashboard page till you get to the database section.

At the database section, click on “phpMyadmin” link, this should open a new window. This new window is where you will be downloading your database.

cpanel database2

Step 3 – Downloading Your Database

Your new window should look like the image below, and on this page, all you need to do is to look at the top navigation and click on the “databases” tab; this will bring up the list of the databases on your server.

[shadowbox]Please note that the number of databases that will come up depends on the amount of sites that you are hosting on your account, if you are hosting just one blog on your hosting account, you will definitely have just one database showing.[/shadowbox]

Select your blog database from the list of databases shown to you and the tables/contents of the database will come up, at the top navigational bar; you will see the “Export” link staring at you over there.

database content

Click the export link and a page like the one below will show up, you don’t need to adjust anything, just click “GO” and your database will begin downloading on to your PC hard drive.

database export

Step 4 – Uploading the Database to Your new Server

Once you are done downloading the database to your hard drive, the next step is to upload the database to your new server.

To do this,

  1. Login to your new server Cpanel, if you don’t know how to do this, then go back to step 1.
  2. Scroll down to the database section (as explained in step 2 above)
  3. Click on “MySql Databases”, this will take you to a new page where you can create a new database.
  4. Enter a name for your database and click Create
  5. After creating your database, go back to the MySql database page again, and scroll down this time till you get to the MySql users section. In this section, create a new user for your database and after creating, go to “add user to database” to add the new user to your blog database that you created above.
  6. After that is done, go to your new server Cpanel home/dashboard and scroll down to the database section, and Click on “phpMyAdmin” and this will open a new window again.
  7. On the Phpmyadmin window, click on database from the top navigation like we did before and you should be able to find the database you created listed there.
  8. Click on this database and page containing its content will come up, once this page shows up, just click on “Import” from the top navigation bar.
  9. Click on “choose file” and select your database that you previously downloaded to your hard drive. Don’t tamper with any other settings on this page, just scroll down a bit and click the “GO” button.

After clicking the Go button, your database upload will begin. Wait for a few minutes for the database to be uploaded to your new server.

Step 5 – Editing your WP-CONFIG FILE

You will need to edit your wp-config file when moving your blog to a new server because you will surely have a change in the database name and database username and you need to update your WordPress configuration with the new settings before your blog and work again!

Doing this is quite easy, just look for the file manager under “files’ on your Cpanel home. A new window should open, at the new window; you should see a list of all your blog files.

website transfer in cpanel

Scroll down till you find the “wp-config” file, right click on it and select “Edit”; I mean just “Edit” and not “edit code”!

A new editing window should open and from there, you can edit your wp-config file. The only thing you need to change in this file is the database name and password which you did set earlier in Step 4.

Once you update this file, click on “save” and you are done with the transfer of your blog to a new server.

All things being equal, if you have changed your domain name servers to your new host name servers, then your blog should be working perfectly well.

If you have any questions or problems as regard this tutorial, drop it in the comments and I will gladly help you out.

[shadowbox]Don’t forget that I am up for hire if you need a hand with moving your blog to a new host, my rates are fair so no need to panic. Just hit me up via the contact form.[/shadowbox]

About the Author Joseph Adediji

Joseph is a Web Enthusiast, a Tech Lover, Writer and an Internet Para-Addict!.I am the Founder of Blogging Tips Today. I love to write about Blogging, SEO, Internet Marketing and Technology.

follow me on:
16 comments
Mike Howg says

Very useful article. I’ve never had to move hosts before but it’s nice to know that it’s possible. The great thing about it is that it doesn’t even seem that difficult as long as your host uses Cpanel.

    Joseph Adediji says

    Hi Mike,
    Yea, it is not that difficult with cpanel, cpanel is fun and easy to use. good to know you have never switched hosts.
    BTW, which web host are you using?

nikhil20 says

Hi Joseph,

Great tutorial to shift database from one place to another. This tutorial seems useful.
Thank you for sharing this with us.

Nikhil Bille says

Recently I migrate my blog blogger to WordPress. But now I used on host account but they are going also maintenance mode or server down. Therefore I want to transfer to new host without losing single comment and article.
Thanks for giving detailed tutorial. I will try it now. Thanks.. Joseph. 🙂

    Joseph Adediji says

    Hi Nikhil,
    Glad you found the article useful.do let me know if you encounter any problem or need any help.

      Nikhil Bille says

      Hi Joseph,
      Thanks for knowing to you are helping me. Can you tell me How can I contact you. By mail or through Facebook.?

        Joseph Adediji says

        Hi Nikhil, you can send me a mail to – admin [at] bloggingtipstoday.com

Harsh Raichura says

Really Helpful Post Again i daily follow your blog and everyday i will get new to learn or know keep it up Man 🙂

    Joseph Adediji says

    Hi Harsh,
    good to know you are a fan! and am glad you found the post helpful.
    have a nice day.

Mathew Yard says

Hello Joseph,

Just found your post, I was searching exactly for something like this. Looks like it’s detailed described and HQ tutorial. I was following your steps and stuck at the part where I need to download my database, when I click the phpMyAdmin it says I don’t have access to this. So am I doing some mistake here? I don’t have VPS but shared hosting so I can’t access to WHM. Is there some other way to download my database please?

Thanks a lot in advance and for your tutorial!

    Joseph Adediji says

    Hi Mathew,
    glad you found the post helpful. For the phpMyAdmin issue, I believe you should have access to this tool, if you are getting a restriction message, then you should contact your web hosting company and tell them to grant you access to your database.
    I don’t know why on earth your host will block you from accessing phpMyAdmin, just mail them and I know they will give you access to it. There is no other easy way to do this other than using phpMyAdmin.
    Contact your web host and give me a feedback about this issue.

      Mathew Yard says

      Hi Joseph,

      Good news! I asked my hosting support and they unblocked this feature for my account. Yeah like you say I don’t know why they’re blocking it o.O But it’s ok now.

      Thanks a lot for your help and being kind, appreciate that 🙂

      Best regards,
      Mathew

        Joseph Adediji says

        Hi Mathew,
        Glad you got it fixed, I think they may have blocked your phpMyadmin access for security purpose, various hosting companies have their own style. Am glad everything is working okay now. If you have any further questions, feel free to post them here.

Eric luke says

It´s a great article, Thank you very much for providing such a wonderful information. It was really helpful for me.

Comments are closed