Hello, in my center the previous persons which managed Mediawiki created the main tables with a prefix namespace like this:
| tier1operationsarchive | | tier1operationsblobs | | tier1operationsbrokenlinks | | tier1operationscategory | | tier1operationscategorylinks | | tier1operationschange_tag | | tier1operationscur
etc...
I wanted to ask if it is possible for me to change all the tables name into something more readable like the default mediawiki tables remoing the awful prefix:
archive blobs brokenlinks category categorylinks
or if this operation is somewhat dangerous.
I also wanted to ask if it is possible for me to delete tables which are not used anymore by Mediawik and they are slso empty, like:
mysql> select * from tier1operationsblobs; Empty set (0.00 sec)
thnk you very much
Rick
On Thu, May 20, 2010 at 3:34 AM, Riccardo Veraldi < Riccardo.Veraldi@cnaf.infn.it> wrote:
I wanted to ask if it is possible for me to change all the tables name into something more readable like the default mediawiki tables remoing the awful prefix:
This is fine; don't forget to change $wgDBprefix when you're done.
I also wanted to ask if it is possible for me to delete tables which are not used anymore by Mediawik and they are slso empty, like:
mysql> select * from tier1operationsblobs; Empty set (0.00 sec)
Yes. Make sure tables aren't in tables.sql before you delete them. (blobs was removed 5 years ago, so you should be safe. :))
mediawiki-l@lists.wikimedia.org