Manual:sqlite.php

This page is a translated version of the page Manual:Sqlite.php and the translation is 44% complete.
MediaWiki バージョン:
1.16 – 1.35


詳細

sqlite.php file is a maintenance script for tasks specific to SQLite backend. This script has been moved to SqliteMaintenance.php in MediaWiki 1.36.

オプション/引数

オプション 説明 必須かどうか
--vacuum Executes VACUUM command that compacts the database and improves its performance. 省略可能
--integrity Performs integrity check of the database. If no error is detected, a single "ok" will be displayed, otherwise the script will show up to 100 errors. 省略可能
--backup-to Backups the database to the given file. 省略可能
--check-syntax Checks SQL files for compatibility with SQLite syntax. This option is intended for developer use. (Added in MediaWIki 1.17) 省略可能

All these options can be used at the same time.

使用法

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


Checking integrity

Terminal
$ php maintenance/sqlite.php --integrity

Performing database integrity checks:
ok

Vacuum Operation

Terminal
$ php maintenance/sqlite.php --vacuum

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

関連項目