|↑ 手冊:索引||MediaWiki database layout||MariaDB/zh|
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
mysql -u wikiuser -p my_wiki
$ 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>.
- Further information: 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).
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.
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.
- Further information: 手册：从XML备份文件文件导入
- Further information: 手册:备份一个维基