Open main menu

Podręcznik:MySQL

This page is a translated version of the page Manual:MySQL and the translation is 33% complete.
Other languages:
Deutsch • ‎English • ‎Nederlands • ‎español • ‎français • ‎italiano • ‎lietuvių • ‎polski • ‎português do Brasil • ‎slovenčina • ‎अवधी • ‎中文 • ‎日本語 • ‎한국어
Podręcznik:Spis treści MediaWiki database layout MySQL/pl


The MySQL and MariaDB database engines are 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.

Connecting to MySQL or MariaDB

mysql -u wikiuser -p wikidb

Change wikiuser and wikidb to the username and database name for your wiki ($wgDBuser and $wgDBname).

potem wprowadź hasło, następnie

Przykład

$ 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>.

Instalacja

Dodatkowe informacje: Manual:Installing MediaWiki#Create a database

Basically, if MySQL or MariaDB is installed, the installation script can create a database for you. Just supply the script with your mysql root password (by default blank).

  Uwaga: 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

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.

Importowanie bazy danych

Dalsze informacje: Manual:Importing XML dumps

Eksportowanie bazy danych

Zobacz też

Linki zewnętrzne