WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a remote (website) version of a wordpress site and it's got more recent information than my local (computer) version.

I would like to move the data over to my local using phpMyAdmin, what is the best way to go about this?

Should I just export the entire database, import it and re-link my wordpress site to the "new" (more recent) database in the config file?

share|improve this question

I would do this so.

But this is probably not the most efficient way accomplishing this task.

There are several plugins out there, that may automate this. If anyone knows one, that is good, I would like to hear about it.

Plugins that look promising:

Find more at:

share|improve this answer

This seemed to work for me (although, to be honest I wasn't too attached to my local database, so if I lost it...)

From "online" version
Go to phpMyAdmin
Export SQL (Structure and data)


On "local" computer version
Write down the name of the database
Drop the database. 
Open the SQL file you exported.
Do a find and replace:
replace with:

Choose the wordpress database in phpMyAdmin.
Import the SQL
share|improve this answer

Your Answer


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.