I am working to a restyle of a website.

I made DB dump from remote server and made local installation, then started to work on my local machine.

While i've been working other post have been added to remote site, so database has new entry that i missed.

Now i need to put online my restyled site and integrate the new entries in my DB. How can i do this? Using Export/import tool would overwrite my new DB?

NOTE: The structure of new db is completely alterated from the old one: got new Post-type, categories, custom fields, ecc...


Try using the export/import feature visit Tools Export Screen.

  • Does exported file overwrites my new structure? Sep 19 '12 at 14:52
  • It shouldn't but backup your new databases before doing this, just in case something else goes wrong with the import.
    – Lee
    Sep 19 '12 at 15:20
  • A sure way to test if your file will be overwritten is to set up a testing environment on your localhost, export your new DB, set up a new WP install on your machine, import the old db and see if your data is changed, erased or unaffected.
    – jhussey
    Sep 19 '12 at 18:49
  • There is a new plugin : Versionpress stackoverflow.com/a/55243047/4217721 Mar 19 '19 at 14:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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