Just create a new database, copy one of your current user tables there, set $wgSharedDB, then delete the old user tables after you're sure it's working.

~Daniel Friesen (Dantman, Nadir-Seen-Fire) ~Profile/Portfolio: http://nadir-seen-fire.com -The Nadir-Point Group (http://nadir-point.com) --It's Wiki-Tools subgroup (http://wiki-tools.com) --The ElectronicMe project (http://electronic-me.org) -Wikia ACG on Wikia.com (http://wikia.com/wiki/Wikia_ACG) --Animepedia (http://anime.wikia.com) --Narutopedia (http://naruto.wikia.com)

Samuel Richardson wrote:

I'm wondering what the best approach is for me to set up a shared user table between my wikis.

Each wiki is sharing the same code (via symlinks) but a different databases. Do I:

a. Merge all the wikis into one database using prefixes, then setup the shared user table (straightfoward) b. Some how connect the seperate databases together. Can MySQL Alias/Symlink a table to another database?

Thanks,

Samuel Richardson Freelance Web Developer www.richardson.co.nz | 0405 472 748

Have you added your business to the Melpedia yet? http://www.melpedia.com.au