Manual:Sqlite.php

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

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 &lt;file name&gt;: Backups the database to the given file.


 * --check-syntax &lt;one or more file names&gt;: 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.