Manual:sqlite.php
Jump to navigation
Jump to search
| MediaWiki file: sqlite.php | |
|---|---|
| Location: | maintenance/ |
| Source code: | master • 1.35.2 • 1.31.14 |
| Classes: | SqliteMaintenance |
| MediaWiki version: | ≥ 1.16 |
Details[edit]
sqlite.php file is a maintenance script for tasks specific to SQLite backend.
Options[edit]
Currently, these 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
- --backup-to <file name>
- Backups the database to the given file.
| MediaWiki version: | ≥ 1.17 |
- --check-syntax <one or more file names>
- Checks SQL files for compatibility with SQLite syntax. This option is intended for developer use.
All these options can be used at the same time.