Grimoire-
Command
.es

GNU+Linux command memo

Check, repair and clean databases

database repair optimize compression

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

Selection

  • Put colors in your console
  • Check SSD remaining lifetime
  • Cipher external Android SDcard
  • Save data from lost partition
  • Mount /tmp in RAM via tmpfs
  • Queue file copies with Task Spooler
  • Extract site PDFs with doc_crawler.py
  • 20 mémos "ligne de commande"
  • [Mémo 8] compression de fichiers
  • [Mémo 10] explorer le matériel
  • Tectonique de la pâte thermique

Themes  

  • Article
  • Artix
  • Debian
  • Fairphone
  • Firefox
  • JavaScript
  • KVM
  • Mutt
  • Python
  • SSH
  • Tor
  • Vim
  • X11
  • adminsys
  • android
  • benchmark
  • bluetooth
  • code
  • comfort
  • compression
  • database
  • date
  • find
  • hardware
  • install
  • memo
  • metadata
  • mount
  • music
  • network
  • optimize
  • repair
  • security
  • shell
  • storage

Sponsor

Meta-Press.es: press search-engine

Patreon

Support via BTC 12z7pK5YFcmG7PGJ985dFtnRzwtxDVDmwc

A propos  Flux