Thread:Project:Support desk/Updating multiple table prefixes at the same time?

I have a little bit of an unconventional setup for my wiki family, I have one central wiki and 3 other wikis connected to it directly, due to most folders (with the exception of "cache", "images" and "mw-config") replaced with symlinks to the central wiki. Everything works completely fine, except for one thing, updating - which technically works too, but is a bit painful to do.

See, the "maintenance" folders are symlinked to the central wiki too, they won't work properly by themselves anyway due to other folders also symlinked, however, running the update script from the central wiki only updates the database prefix for the central wiki, to update the 3 other wikis I have to go into the LocalSettings.php of my central wiki and replace the DB prefix with each of the 3 wikis'. Even worse is that some people have asked if I could host their wikis, and I've agreed, but this would mean the update progress would be even more painful.

I've looked into the update script but I'm not exactly sure how I could define which prefixes to update, or if I could specify a certain prefix to update.

FYI, my wikis do share quite a bit of stuff, and I'm wondering if maybe I have set up my shared database wrong, due to the fact that installing extensions like Extension:GlobalCssJs and Extension:GlobalUsage proved impossible, with a "Database query error" every time.

This is all of code related to the shared database:

$wgSharedDB = 'mydb'; $wgSharedPrefix = 'lobby_'; $wgSharedTables = ['spoofuser', 'site_stats', 'user', 'user_properties', 'interwiki', 'ipblocks'];

(I changed the $wgSharedDB due to the fact that I'd rather not release my site to the public at the moment.)