Manual:Sqlite.php/ja
 | この機能は、バージョン 1.36 で完全に除去されました。 |
| MediaWiki バージョン: | 1.16 – 1.35 |
| MediaWiki ファイル: sqlite.php | |
|---|---|
| 場所: | maintenance/ |
| ソース コード: | master • 1.44.0 • 1.43.3 • 1.39.13 |
| クラス: | SqliteMaintenance |
詳細
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).