Manual:SqliteMaintenance.php/ja

From mediawiki.org
This page is a translated version of the page Manual:SqliteMaintenance.php and the translation is 31% complete.
Other languages:
MediaWiki バージョン:
1.36


Details

SqliteMaintenance.php file is a maintenance script that performs some operations specific to SQLite database backend.

オプション/引数

オプション 説明 必須かどうか
--vacuum Clean up database by removing deleted pages. Decreases database file size 省略可能
--integrity Check database for integrity 省略可能
--backup-to Backup database to the given file 省略可能
--check-syntax Check SQL file(s) for syntax errors 省略可能

使用法

php maintenance/SqliteMaintenance.php [ --vacuum| --integrity| --backup-to| --check-syntax ]

Checking integrity

Terminal
$ php maintenance/SqliteMaintenance.php --integrity

Performing database integrity checks:
ok

Vacuum Operation

Terminal
$ php maintenance/SqliteMaintenance.php --vacuum

VACUUM: Database size was 46995456 bytes, now 37796864 (19.6% reduction).

Checking SQL file syntax

patch-actor-table.sql
--
-- patch-actor-table.sql
--
-- T167246. Add an `actor` table.

CREATE TABLE /*_*/actor (
  actor_id bigint unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
  actor_user int unsigned,
  actor_name varchar(255) binary NOT NULL
) /*$wgDBTableOptions*/;
CREATE UNIQUE INDEX /*i*/actor_user ON /*_*/actor (actor_user);
CREATE UNIQUE INDEX /*i*/actor_name ON /*_*/actor (actor_name);
Terminal
$ php maintenance/SqliteMaintenance.php --check-syntax patch-actor-table.sql

SQL syntax check: no errors detected.

See also