I designed a WordPress system for a friend, and run it on my server. Having seen it, a whole bunch of other friends wanted exactly the same system. Because I didn't really have time to think about it, I just set up identical blogs, copied the original database and then customised them for the different URLs and users etc. They are all running on my server, each with a different URL, and each with a discrete database.
Thing is, there are quite a few of these blogs now, and it seems to me rather inefficient to have six or seven separate databases. I know if I were setting them up from scratch I could just specify a prefix for each installation and use one database, but after the fact is there any way of copying all of the tables within an existing database and appending a prefix to them so that I can then import those tables into one single database? I'm not very knowledgeable about SQL and any experiments I've ever done in this area have failed.
Any thoughts would be greatly appreciated!