Hi,
I suppose the original question was not based on such a situation. He (Gadget Doctor) hasn't mentioned about multiple wiki projects in his installation. So, simple answer was he can do away with the table prefix. Even if he wants to add more projects later, he can add prefixes to the new tables.
Another point- you mentioned that "Mediawiki has 136 separate tables per-install". But in my MW 1.11, I can see only around 50 tables. Am I missing something?
Regards,
Jack ---------------------------------------------------------------- "May He protect us both. May He cause us both to enjoy.May we exert together. May our studies become brilliant. May we not hate each other"
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of David A. Desrosiers Sent: Tuesday, February 05, 2008 7:24 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Is there any reason to use a table name prefixifyou don't have to?
On Tue, 2008-02-05 at 19:07 +0530, Jack Eapen C wrote:
Even if you use same database for multiple applications, it's not necessary to use a table prefix. A table prefix will only help you while viewing the table names-if you use a prefix, you can see all the
mediawiki tables together.
Not quite. Mediawiki has 136 separate tables per-install. If you wanted to use a single-database solution (which certain types of MW install are easier to manage in this fashion), your only option is to use table prefixes.
In my particular case [ http://projects.plkr.org/encycloplucker/ ], I have 9 langauges against 6 wiki projects (books, news, quote, source, etc.) in one database for ease of management (rapid import/export operations).
This brings the total number of tables to a whopping 7,344 if I import them all at once (54 wikis * 136 tables in each).
Without using 54 separate databases (functionally not possible in this case, because I'm using just one instance of the Mediawiki source to host all of these wikis), how do you propose a solution that does not involve table prefixes?
-- David A. Desrosiers desrod@gnu-designs.com Skype...: 860-967-3820
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
This electronic mail (including any attachment thereto) may be confidential and privileged and is intended only for the individual or entity named above. Any unauthorized use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. Accordingly, if you are not the intended recipient, please notify the sender by replying to this email immediately and delete this email (and any attachment thereto) from your computer system...Thank You