Manual:sqlite.php

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

File:OOjs UI icon alert-destructive.svg

<translate> This feature was removed completely in version <tvar name=ver>1.36</tvar>.</translate>

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>">

1.16 – 1.35

<translate> MediaWiki versions:</translate>

MediaWiki file: sqlite.php
Location:	maintenance/
Source code:	master • 1.41.1 • 1.40.3 • 1.39.7
Classes:	SqliteMaintenance

Details

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

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

All these options can be used at the same time.

Usage

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