Manual:sqlite.php

From mediawiki.org
MediaWiki versions:
1.16 – 1.35


Details[edit]

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.

Options/Arguments[edit]

Option Description Required?
--vacuum Executes VACUUM command that compacts the database and improves its performance. Optional
--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. Optional
--backup-to Backups the database to the given file. Optional
--check-syntax Checks SQL files for compatibility with SQLite syntax. This option is intended for developer use. (Added in MediaWIki 1.17) Optional

All these options can be used at the same time.

Usage[edit]

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


Checking integrity[edit]

Terminal
$ php maintenance/sqlite.php --integrity

Performing database integrity checks:
ok

Vacuum Operation[edit]

Terminal
$ php maintenance/sqlite.php --vacuum

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

See also[edit]