Display information from multiple databases

I currently use multi-db and created 256 databases. It has worked perfectly for me. However, now I am trying to retrieve information from the various sites that I created and am having difficulty doing this. I do not want to access each site or their database to gather the information...I would like to pull the information together in one place to access it. Can this be done? If so, can you lead me in the right direction?

For example, I use a sms plugin. Can I gather phone numbers from within all the websites in one easy step...or create a process that allows me to access them in one easy step?


  • aecnu

    Greetings bdonaghy,

    This cannot be easily done, if at all.

    The challenges would be that the databases are strewn about rather randomly throughout the entire Multi DB system and therefore for this to be successful it would almost take a magician to go through and figure out:

    A) Database location and then related tables.

    B) Aggregate all the relative data to another database for remote retrieval as described in your post.

    C) This would be an entire program unto itself.

    Therefore I regrettably admit that this is way beyond the mandate of this forum and suggest that at minimum it is a custom job and a tough one at that.

    You could see if there's a developer available at wpmu jobs who could get onto it right this minute.

    Cheers, Joe