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(a)gnu-designs.com
Skype...: 860-967-3820