I’m contemplating finally migrating one of my sites to a multiple install site structure. I was reluctant to do this in the past because of the I wanted a central search function but with the mod on the download page this now looks much more straight forward and attractive.
My plan is to create multiple installs linked to one database containing prefixed tables. I wondered if you could suggest if there is any easy way to duplicate the existing set of dB tables to create a new set with a new prefix. My site is highly customised so I can’t just create a new installation and generate a standard set of tables as half the fields would be missing. Also, I’m planning to expand and create new installs in the future so any kind of solution that didn’t involve copy pasting/renaming tables would be great!
Thanks in advance.