Manual:sql.php

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.10

<translate> MediaWiki version:</translate>

Arquivo MediaWiki: sql.php
Local:	maintenance/
Código fonte:	master • 1.41.1 • 1.40.3 • 1.39.7
Classes:	MwSql

File:OOjs UI icon notice-destructive.svg <translate> Warning:</translate>

Since MediaWiki 1.28, sql.php may have some side effects. Please make sure you have run update.php and things do not break before running this script!

<translate> Tracked in [[<tvar name=1>phabricator:</tvar>|Phabricator]]</translate>
<translate> Task <tvar name=1>T157651</tvar></translate>

sql.php é um arquivo de manutenção que executa consultas SQL de um arquivo específico para o banco de dados. If you give an SQL file as the first argument, it will replace MediaWiki specific code comments like /*_*/ for the configured database prefix (among others). If you don't give it a file, then you can query the database in an interactive fashion, similar to the MySQL command line tool.

This script is often used if you want to upgrade MediaWiki, but have a large, master/replica-database setup and don't want any downtime. Instead of using update.php, you might use sql.php to apply database individual patches from maintenance/archives directory on each sql server separately, taking the individual server out of rotation while the schema change runs. Generally you should only do this if you have to - most users should use the update.php script instead.

Options/Arguments

As opções disponíveis para este script a partir da linha de comando são:

Option	Description	Required?
--query	Run a single query instead of running interactively	<translate> Optional</translate>
--json	Output the results as JSON instead of PHP objects	<translate> Optional</translate>
--status	Return successful exit status only if the query succeeded (selected or altered rows), otherwise 1 for errors, 2 for no rows	<translate> Optional</translate>
--cluster	Permite que um nome de cluster seja fornecido para o comando.	<translate> Optional</translate>
--wikidb	Permite a um banco de dados diferente ser usado no comando pela ID, se não for o banco de dados atual.	<translate> Optional</translate>
--replicadb	Replica DB server to use instead of the primary DB (can be "any")	<translate> Optional</translate>

Usage

php maintenance/sql.php [ --query| --json| --status| --cluster| --wikidb| --replicadb ]

Interactive mode

Terminal

$ php maintenance/sql.php

>

Inline query

Terminal

$ php maintenance/sql.php --query "SELECT user_name from user;"  --json

[
    {
        "user_name": "Delete page script"
    },
    {
        "user_name": "Foo"
    },
    {
        "user_name": "Maintenance script"
    },
    {
        "user_name": "MediaWiki default"
    },
    {
        "user_name": "ScriptImporter"
    }
]

Applying patches

Terminal

$ php maintenance/sql.php maintenance/archives/patch-actor-table.sql

Query OK, 0 row(s) affected
Query OK, 0 row(s) affected
Query OK, 0 row(s) affected

Ver também