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

1 Answer

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