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?

2 Answers 2


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:


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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