phone number

A creative, friendly web design company based in Chelmsford, Essex

back light

Export Database To New WordPress Host

You may have come across this error message when trying to import your recently exported wordpress database when moving your WordPress blog to a new hosting provider…

“import #1044 – Access denied for user error”

Disheartening it might be after overcoming the worry of losing all your files, comments and blog posts by managing to update the wp_config file correctly. But this should be relatively simple to overcome.

database export

Ok, let’s presume to get this far you have created a new mySQL database in your new host and assigned the correct ‘DB_NAME’, ‘DB_USER’ and ‘DB_PASSWORD’ and added them to the the wp_config file.

Now, let’s presume that instead of the ‘error establishing a database connection’ (which primarily means that the above name, user and password are not 100% correct) you can see that WordPress exists on your new host, but it is asking you to create a blog from scratch.

The most likely cause of this is that your new database has no tables in it – that it is empty. But you’ve got this far already right? Because you have got the ‘import #1044 – Access denied for user error’ showing when trying to add your existing database to your new host.

The Probable Solution

Other posts offer solutions suggesting that you need to go back to your original WordPress blog to a new host, add a new user that replicates the user that you have created on your new hosting provider…. but hold on, it’s not that complicated.

You need to download the tables from your existing database from your old host, then import these tables (they will be in one file) to your newly created database in your new host.

How To Do this

php myadminLog into the cPanel in your old host, scroll to Databases and click on phpMyAdmin, then click on the database name in the left sidebar. You should now see the relevant database with all the tables showing.

So now click ‘check all’ at the bottom, then click ‘export’ at the top. When the new page opens, hit ‘go’ and you will download the tables.

export databaseOnce this is done, go to your new database, and do exactly the same procedure to see the tables – you will probably see confirmation that this database is empty and has no tables. Now hit ‘import’ at the top, then select the file containing the tables from your old database, then hit ‘go’.

With luck and a favourable wind, there should be no error message this time, and your new database will now contain all the tables that your old database had. Your blog should retain the design that you intended, the only difference being that the database name, user and password will have changed which you have already updated in the wp_config file.

Refresh, and reload the page and you should now see your WordPress blog show up on your new host!

Share this..
Tweet about this on TwitterShare on FacebookShare on Google+Share on LinkedInPin on PinterestEmail this to someoneShare on TumblrShare on StumbleUponShare on Reddit

Tags: , , , , ,

One Response to “Export Database To New WordPress Host”

  1. Tremendous issues here. I am very happy to see your post.
    Thanks a lot and I’m having a look ahead to contact you.
    Will you please drop me a mail?

Leave a Reply

Please complete the sum so we know you\'re a human... *