Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I'm trying to migrate my wordpress site from an old host to a new host. The Wordpress Codex says "you can move by just copying your files and database." Copying the files is easy enough, but how do I copy my database? I'm sure I'm just not looking in the right places, but I can't find any documentation on this anywhere.

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

The same WordPress Codex has a page for backing up your database with phpmyadmin; see http://codex.wordpress.org/Backing_Up_Your_Database

You must export and import the database itself - and not do a posts export from the dashboard - to retain all settings, image URLs, etc.

Either use phpmyadmin in your host control panel, or you can use it as a plugin called Portable phpmyadmin: http://wordpress.org/extend/plugins/portable-phpmyadmin/

But if you use the plugin, you may have to try an older version, as the newer alpha version doesn't work on some web hosts due to host restrictions.

And, if you are changing domains as well as hosts, you need to correctly change URLs in the database. interconnectit.com WordPress Serialized PHP Search Replace Tool

share|improve this answer
    
"How to move wordpress.." link is dead.. –  hitautodestruct Mar 5 at 13:04
add comment

Most hosting companies have a mysql viewer like phpmyadmin installed which lets you export the database. You can also export it by going to export under tools in the admin panel although this will not export some settings (plugin settings), so it is much better to use phpmyadmin if you can.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.