Manual:MySQL

This page is a translated version of the page Manual:MySQL and the translation is 31% complete.

Outdated translations are marked like this.

Languages:

MediaWiki database layout

MySQL/es

The MySQL database engine is the most commonly-used database backends for MediaWiki. Since MySQL used to be the relational database management system used by the Wikimedia Foundation websites, it is well-supported in MediaWiki. Much of the advice for MySQL and for MariaDB apply to each other.

See Compatibility#Database for a list of supported versions.

Conexión a MySQL/MariaDB

 mysql -u wikiuser -p my_wiki

Change wikiuser and my_wiki to the username and database name for your wiki ($wgDBuser and $wgDBname ). Cambia wikiuser y wikidb por los nombres de usuario y de base de datos de tu wiki ($dbuser y $dbname). Cuando sea necesario, escribe tu contraseña.

Ejemplo

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

Instalación

Más información: Manual:Installing MediaWiki#Create a database

Básicamente, si MySQL o MariaDB están instalados, el script de instalación puede crear una base de datos para ti. Just supply the script with your MySQL root password (by default blank).

Advertencia:

Dejar la contraseña de root en blanco puede comprometer seriamente la seguridad de la instalación de MediaWiki. 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.

Mantenimiento

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

Más información: Manual:Importación de volcados XML

Export database

Más información: Manual: Hacer una copia de seguridad de un wiki

Véase también

Enlaces externos

MySQL Reference Manual