|↑ Manual:Contents||MediaWiki database layout||MySQL/fr|
The MySQL database engine is the most commonly-used database backend for MediaWiki. Since it is the relational database management system used by the Wikimedia Foundation wiki farm in its own websites, it is well-supported in MediaWiki.
Connecting to MySQL[edit | edit source]
mysql -u wikiuser -p wikidb
Exemple[edit | edit source]
$ mysql -u root -p wikidb 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 | edit source]
- Further information: Manual:Installing MediaWiki#Create a database
Basically, if MySQL is installed, the installation script can create a database for you. Just supply the script with your mysql root password (by default blank).
|Warning:||Leaving the MySQL root password blank can seriously compromise the security of the MediaWiki installation. You should modify the password if you haven't already.|
Note : 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 | edit source]
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 | edit source]
- Further information: Manual:Importing XML dumps
Export database[edit | edit source]
- Further information: Manual:Backing up a wiki