Title: Converting multiple blogs using same database to single multisite Last modified: August 19, 2016 --- # Converting multiple blogs using same database to single multisite * [zamba](https://wordpress.org/support/users/zamba/) * (@zamba) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/) * Hi All, I’m on shared hosting at Pair.com (LAMP). My site consists of several wp 2.92 blogs in sub-folders off the web root. These blogs use a single database with the tables having individual prefixes. I now wish to merge these blogs into a single wp 3.0 network. Is there a simple way of doing this, bearing in mind the blogs already use the same database? Or do I have to start from scratch with the export/import procedure? * If anyone could throw some light on this I’d be grateful, if there is a simpler way it would certainly save me a lot of time (I have multiple examples of this situation to deal with). * Tony Page Viewing 10 replies - 1 through 10 (of 10 total) * [Andrea Rennick](https://wordpress.org/support/users/andrea_r/) * (@andrea_r) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598559) * How comfortable are you with working in the database directly? * Thread Starter [zamba](https://wordpress.org/support/users/zamba/) * (@zamba) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598685) * Hi Andrea, * Sorry for delay in responding, I’m in Sydney, Australia. * I’d describe my ability to do that as basic, essentially limited to working via php admin at the “follow instructions” level. I am not a programmer and have only a rudimentary knowledge of coding. Sorry! * Tony * PS Of course, I could maybe pay someone more capable to do it, if this was a basically straightforward operation… * [Andrea Rennick](https://wordpress.org/support/users/andrea_r/) * (@andrea_r) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598707) * Well nobody’s written a step by step for this particular situation, but if they are all in the same db, it involves renaming tables and shuffling some things around. * I’d say intermediate level. * Thread Starter [zamba](https://wordpress.org/support/users/zamba/) * (@zamba) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598710) * Copy that. When it comes to ground-breaking, I wouldn’t feel happy unless I was at least one skill level above that notionally required, which rules this process out for me, I think. * So if I want to do it myself, I’d have to basically start from scratch, export all the blogs, install and specify one blog as lead, and then re-import the rest from the back-ups into the network? Presumably, it’s preferable to start with a clean database, so at least I can keep everything running until the last moment. * Has anyone else done this and can give me any heads-ups as to possible snafus? * Tony * [Andrea Rennick](https://wordpress.org/support/users/andrea_r/) * (@andrea_r) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598711) * Yep. That’s the slow-but-works way. * possible snafus only really relate to media uploads. [http://ottopress.com/2010/wordpress-3-0-multisite-attachment-handling/](http://ottopress.com/2010/wordpress-3-0-multisite-attachment-handling/) * Thread Starter [zamba](https://wordpress.org/support/users/zamba/) * (@zamba) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598734) * Thanks, Andrea, that’s very helpful. So the images embedded in a post would be OK, but any attachments would need to have their links amended? * [Andrea Rennick](https://wordpress.org/support/users/andrea_r/) * (@andrea_r) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598742) * If they are embedded in a post, where are they linked to? your install? If offsite, no. If on your install…. then…. yes… * I’ve often set up two images folders, one for legacy links and then copies in the new one. * > but any attachments would need to have their links amended? * any attachments _may_ need to have their links amended. * Thread Starter [zamba](https://wordpress.org/support/users/zamba/) * (@zamba) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598745) * Good grief, we have a minimum of one image on each post, uploaded to the media library, and a thousand or more posts. I’d assumed (stupidly) that in some mystic way the image links were rewritten – pretty dumb, now I come to think of it. * So the easiest way to solve this is to maintain my current uploads directory structure for legacy posts. Not elegant, but workable? * I may be slow, but why do you place copies in the new [http://example.com/files/2010/](http://example.com/files/2010/) folder? * [Andrea Rennick](https://wordpress.org/support/users/andrea_r/) * (@andrea_r) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598747) * > I may be slow, but why do you place copies in the new [http://example.com/files/2010/](http://example.com/files/2010/) > folder? * Redundacy in case I missed something. And so they show in the Media area. * Thread Starter [zamba](https://wordpress.org/support/users/zamba/) * (@zamba) * [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598754) * Got it. Thanks for your help on this. I think I’ll take the more conservative approach and see how I go. If I split the approx. 40 blogs into 5 separate multisite installations, that should free up a lot of maintenance time while avoiding putting all my eggs in one basket (too chicken for that!). Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘Converting multiple blogs using same database to single multisite’ is closed to new replies. ## Tags * [Single Database](https://wordpress.org/support/topic-tag/single-database/) * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/) * 10 replies * 2 participants * Last reply from: [zamba](https://wordpress.org/support/users/zamba/) * Last activity: [15 years, 10 months ago](https://wordpress.org/support/topic/converting-multiple-blogs-using-same-database-to-single-multisite/#post-1598754) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics