Manual:sqlite.php

From MediaWiki.org

Jump to: navigation, search
MediaWiki File: sqlite.php
Location: /maintenance/
Source code: HEAD

1.15.11.14.11.6.12

Classes: None
MediaWiki version: 1.16

sqlite.php is a maintenance script for tasks specific to SQLite backend.

Currently, two options are supported:

--vacuum
Executes VACUUM command that compacts the database and improves its performance.

Example:

$ php sqlite.php --vacuum
VACUUM: Database size was 46995456 bytes, now 37796864 (19.6% reduction).
--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.

Example:

$ php sqlite.php --integrity
Performing database integrity checks:
ok

Both options can be used at the same time.