Skip to content

Instantly share code, notes, and snippets.

@rezhajulio
Created September 28, 2024 14:34
Show Gist options
  • Save rezhajulio/cd48279f270977fca9ecf8418dd58504 to your computer and use it in GitHub Desktop.
Save rezhajulio/cd48279f270977fca9ecf8418dd58504 to your computer and use it in GitHub Desktop.
sqlite_backup
BACKUP_FILE=backups/`date +%Y%m%d_%H%M`.db
sqlite3 -readonly path/to/your.db ".backup $BACKUP_FILE"
sqlite3 $BACKUP_FILE "vacuum;"
bzip2 -9 $BACKUP_FILE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment