Movatterモバイル変換


[0]ホーム

URL:


Jump to content
MediaWiki
Search

Manual:$wgDBprefix

From mediawiki.org
Translate this page
Languages:
Database settings: $wgDBprefix
Table name prefix.
Introduced in version:1.4.0
Removed in version:Still in use
Allowed values:(string)
Default value:''
Other settings:Alphabetical |By function

Details

[edit]

Table name prefix.This should be alphanumeric, contain neither spaces nor hyphens, and end in "_".If you only have access to a single database and wish to install more than one version of MediaWiki, or have other applications that also use the database, you can give the table names a unique prefix to stop any naming conflicts or confusion.

For example, if you use the prefix 'wiki_' then the table 'page' will be named 'wiki_page' instead.

You need to set this at the time of initial configuration, or manually change the table names at a later date.Changing this setting does not automatically update the names of the tables in your database.

This setting isNOT used if your database is PostgreSQL: instead,schemas are used (see$wgDBmwschema).[1]

Common value

[edit]

Many installers set the database table prefix "$wgDBprefix" to "mw_" by default.[2][3][4]

Caution!Caution:
  • Do not change$wgDBmwschema afterSetup.php has been included.Note:Setup.php initializes various paths, includes some common files, starts sessions, and performs various other setup tasks for a request. It is not related to the installation or setup of MediaWiki.
  • Only files inincludes/db/ should use$wgDBmwschema, while everything else should use thedbSchema() method provided by theWikimedia\Rdbms\IDatabase interface or extract it from thegetDomainId() method in either theWikimedia\Rdbms\ILoadBalancer or theWikimedia\Rdbms\ILBFactory interface. TheDatabaseDomain class can extract such components from a database domain ID.
  • If you configure$wgDBservers or$wgLBFactoryConf, you still need to define$wgDBname,$wgDBmwschema (if applicable for the DB type), and$wgDBprefix (if applicable for the DB type). The combination of$wgDBname,$wgDBmwschema, and$wgDBprefix define the current wiki'sdatabase domain. This is also called thelocal database domain. The 'dbname' and 'tablePrefix' settings in$wgDBservers and$wgLBFactoryConf only define the default DB/prefix when a connection is requested withDatabaseDomain::newUnspecified()->getId() (the empty string) as the database domain, e.g.wfGetDB( DB_REPLICA, [], '' ). Note that functions calls likewfGetDB( DB_REPLICA ), which simply omit the database domain, are assumed to refer to the local database domain.

References

[edit]
  1. Reminder: Don't set $wgDBprefix when you're using Postgres, 2020-05-18
  2. Mark S. Choate."Professional Wikis".p. 34.
  3. Daniel J. Barrett."MediaWiki: Wikipedia and Beyond".p. 186.
  4. "Table prefix for db tables".


See also

[edit]
Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:$wgDBprefix&oldid=5905497"
Categories:

[8]ページ先頭

©2009-2025 Movatter.jp