Manual:Sql.php/pt
Versão MediaWiki: | ≥ 1.10 |
ficheiro do MediaWiki: sql.php | |
---|---|
Localização: | maintenance/ |
Código fonte: | master • 1.42.3 • 1.41.4 • 1.39.10 |
Classes: | MwSql |
sql.php is a maintenance file which allows performing SQL queries.
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
Available options for this script from the command line are:
Option | Description | Required? |
---|---|---|
--query | Run a single query instead of running interactively | Optional |
--json | Output the results as JSON instead of PHP objects | Optional |
--status | Return successful exit status only if the query succeeded (selected or altered rows), otherwise 1 for errors, 2 for no rows | Optional |
--cluster | Allows a cluster name to be provided for the command. | Optional |
--wikidb | Allows for a different database to be used in the command by ID if not the current database. | Optional |
--replicadb | Replica DB server to use instead of the primary DB (can be "any") | Optional |
Usage
php maintenance/sql.php [ --query| --json| --status| --cluster| --wikidb| --replicadb ]
Interactive mode
$ php maintenance/sql.php >
Inline query
$ 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
$ 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