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 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
add comment

2 Answers

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)

Then:

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:
www.the-online-site-name.com
replace with:
localhost/local-site-name

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

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
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.