On Thu, Aug 6, 2009 at 3:04 PM, Brion Vibber<br...@wikimedia.org> wrote: > On 8/6/09 10:30 AM, Chad wrote: >> Depends on which maintenance script you're talking about. Update.php >> certainly does, as does renameDbPrefix (just to grab one off the top of >> my head). The vast majority of scripts can function just fine with normal >> DB access. Some (mcc and digit2html, to name a few) don't need any >> DB access at all. > > Generally, only updaters need create/alter/etc privs; a few script that > do mass rebuilds of indexes will also want to do things like dropping > and re-adding indexes -- for example rebuildTextIndex drops the fulltext > index on the searchindex table, then re-adds it after refilling the > table's contents. > > And a few "extreme" maintenance ops like MySQL replication master > switches of course will need all kinds of fun privs. ;) > > -- brion > > _______________________________________________ > Wikitech-l mailing list > Wikitech-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikitech-l >
Right, which is what my idea behind getDbType() was (which still needs actual implementation, it's more an idea than practice at the moment). If we don't need root DB access, we shouldn't be using it! If we don't need DB access at all, don't bother connecting. -Chad _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
