Jump to content

Main menu Navigation ●Main page ●Get MediaWiki ●Get extensions ●Tech blog ●Contribute Support ●User help ●FAQ ●Technical manual ●Support desk ●Communication Development ●Developer portal ●Code statistics mediawiki.org ●Community portal ●Recent changes ●Translate content ●Random page ●Village pump ●Sandbox In other languages Add links

● English ●Create account ●Log in ●Create account ● Log in Pages for logged out editors learn more ●Contributions ●Talk

Beginning 1 Connecting to MariaDB 1.1 Example 1.2 Installation 2 Maintenance 3 Import database 4 Export database 5 See also 6 External links

Manual:MariaDB

●Manual ●Discussion ●Read ●Edit ●View history Tools Actions ●Read ●Edit ●View history General ●What links here ●Related changes ●Upload file ●Special pages ●Permanent link ●Page information ●Cite this page ●Get shortened URL ●Download QR code Print/export ●Create a book ●Download as PDF ●Printable version From mediawiki.org

Translate this page

Bahasa Melayu

English

↑ Manual:Contents

MediaWiki database layout

MariaDB

The MariaDB database engine is one of the most commonly-used database backends for MediaWiki. Since MariaDB is the relational database management system used by the Wikimedia Foundation websites, it is well-supported in MediaWiki.

See Compatibility#Database for a list of supported versions.

Connecting to MariaDB[edit]

$ mariadb -u root -p my_wiki

If using a MariaDB 10.3 or earlier:

 mysql -u wikiuser -p my_wiki

Change wikiuser and my_wiki to the username and database name for your wiki ($wgDBuser and $wgDBname ). When prompted, enter your password.

Example[edit]

$ mysql -u root -p my_wiki
Enter password: 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 150
Server version: 5.6.24-0ubuntu2 (Ubuntu)
...

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>.

Installation[edit]

For further information, see Manual:Installing MediaWiki#Create a database

If MariaDB is installed, the installation script can create a database for you. Just supply the script with your RDBMS root password (by default, blank).

Warning:

Leaving the root password blank can seriously compromise the security of the MediaWiki installation. You should modify the password if you haven't already.

If you are installing MediaWiki on an ISP server, you might have to share a db with some other applications, which increases the risk of a conflict between database tables required by MediaWiki with pre-existing tables. To solve this problem you can instruct MediaWiki to use a table prefix, so that all tables of MediaWiki begin with this prefix. Alternatively, if your ISP allows, use different databases for each application that resides on the server.

Maintenance[edit]

Multiple maintenance scripts are included in the /maintenance/ directory of your MediaWiki installation. Some of these scripts are provided to refresh parts of the database as one-time operations.