Manual:SqliteMaintenance.php/pl
| Wersja MediaWiki: | ≥ 1.36 |
| Plik MediaWiki: SqliteMaintenance.php | |
|---|---|
| Lokalizacja: | maintenance/ |
| Kod źródłowy: | master • 1.45.3 • 1.44.5 • 1.43.8 |
| Klasy: | SqliteMaintenance |
Details
SqliteMaintenance.php file is a maintenance script that performs some operations specific to SQLite database backend.
Options/Arguments
| Option | Description | Required? |
|---|---|---|
| --vacuum | Clean up database by removing deleted pages. Decreases database file size | Optional |
| --integrity | Check database for integrity | Optional |
| --backup-to | Backup database to the given file | Optional |
| --check-syntax | Check SQL file(s) for syntax errors | Optional |
Usage
php maintenance/run.php SqliteMaintenance [ --vacuum| --integrity| --backup-to| --check-syntax ]
W wersji MediaWiki MediaWiki 1.39 i we wcześniejszych musisz wywoływać skrypty konserwacyjne poprzez
php maintenance/nazwaSkryptu.php zamiast php maintenance/run.php nazwaSkryptu.Checking integrity
Terminal
$ php maintenance/run.php SqliteMaintenance --integrity Performing database integrity checks: ok
Vacuum Operation
Terminal
$ php maintenance/run.php SqliteMaintenance --vacuum VACUUM: Database size was 46995456 bytes, now 37796864 (19.6% reduction).
Checking SQL file syntax
patch-actor-table.sql
--
-- patch-actor-table.sql
--
-- T167246. Add an `actor` table.
CREATE TABLE /*_*/actor (
actor_id bigint unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
actor_user int unsigned,
actor_name varchar(255) binary NOT NULL
) /*$wgDBTableOptions*/;
CREATE UNIQUE INDEX /*i*/actor_user ON /*_*/actor (actor_user);
CREATE UNIQUE INDEX /*i*/actor_name ON /*_*/actor (actor_name);
Terminal
$ php maintenance/run.php SqliteMaintenance --check-syntax patch-actor-table.sql SQL syntax check: no errors detected.