Manual:MySQL

The MySQL database engine is the most commonly-used database backend for MediaWiki.

The wmf>:foundation:|Wikimedia Foundation wiki farm uses MariaDB, which is a fork of MySQL, consequently MySQL is well-supported in MediaWiki.

Installation


Further information : ''

Basically, if MySQL is installed, the script>Special:MyLanguage/Manual:Config script|installation script can create a database for you.

Just supply the script with your mysql 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.

Maintenance
Multiple scripts>Special:MyLanguage/Manual:Maintenance scripts|maintenance scripts are included in the   directory of your MediaWiki installation.

Some of these scripts are provided to refresh parts of the database as one-time operations.

Import database


Further information : ''

Export database


Further information : ''