Skip to content

Instantly share code, notes, and snippets.

@hightemp
Last active December 18, 2015 23:19
Show Gist options
  • Save hightemp/5860960 to your computer and use it in GitHub Desktop.
Save hightemp/5860960 to your computer and use it in GitHub Desktop.

###Dump data from sqlite

sqlite3 some.db .sch > schema
sqlite3 some.db .dump > dump
grep -v -f schema dump > data

###Load data from file

cat data | sqlite3 database.db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment