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

share|improve this question

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.

share|improve this answer
thank you I will try this. – Barbara Quinn Oct 23 '12 at 20:35
Be aware that the regular WXR file will miss authors without posts. – toscho Oct 23 '12 at 20:38
@toscho: is there a workaround for that? A quick search doesn't reveal one. – markratledge Oct 23 '12 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. – toscho Oct 24 '12 at 7:17

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.