Skip to content

Instantly share code, notes, and snippets.

@mechanical-snail

mechanical-snail/gist:1911714

Created February 25, 2012 23:47
Show Gist options
  • Save mechanical-snail/1911714 to your computer and use it in GitHub Desktop.
Save mechanical-snail/1911714 to your computer and use it in GitHub Desktop.
Download ZIP
Vacuum sqlite without running out of disk space
Raw
gistfile1.txt
Vacuum sqlite without running out of disk space:
TMPDIR=. sqlite dbfile.sqlite
SQLite version 3.7.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> vacuum;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment