Grimoire-
Command
.es

GNU+Linux command memo

Check, repair and clean databases

Vérifier, réparer et nettoyer des bases de données

MySQL: $ mysqlcheck ( --check | --auto-repair | --repair | --optimize ) --all-databases

PostgreSQL: $ vacuumdb -a -z

SQLite:

$ for z in `ls *.sqlite`; do sqlite3 $z VACUUM; done