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.
Import database
[
edit
]
- For further information, see
Manual:Importing XML dumps
Export database
[
edit
]
- For further information, see
Manual:Backing up a wiki
See also
[
edit
]
External links
[
edit
]
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|