I have three databases associated with three different WP sites. I set up one MU site, with one database. How should I import each of the three databases?

1 Answer 1


Best thing to do is read the docs: http://codex.wordpress.org/Tools_Export_Screen and http://codex.wordpress.org/Importing_Content#WordPress and work with WXR files rather than trying to export directly from the database.

You also have the option on Import to grab images. Or you can merge the contents of the three wp-content/uploads/ directories, but be aware that it's possible some images may have the same name and get overwritten.

  • Be aware that the regular WXR file will miss authors without posts.
    – fuxia
    Commented Oct 23, 2012 at 20:38
  • @toscho: is there a workaround for that? A quick search doesn't reveal one. Commented Oct 23, 2012 at 21:39
  • A custom exporter or a hidden custom post type with 'can_export' and one ghost post per user. Not exactly elegant solutions.
    – fuxia
    Commented Oct 24, 2012 at 7:17

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.