Manual:Sql.php

This page is a translated version of the page Manual:Sql.php and the translation is 14% complete.

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

sql.php は、SQL クエリを実行できるようにするメンテナンス用ファイルです。 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.

Example: php sql.php archives/patch-ipb_sitewide.sql

Available options for this script from the command line are:

--cluster Allows a cluster name to be provided for the command.
--wikidb Allows for a different database to be used in the command by ID if not the current database.
--slave Use a slave server for the command (allows any or a specific name).