sqlite3 db dump

Let’s say your db is in the file named my.db. Here’s how you get a dump:

echo .dump | sqlite3 my.db > dump.sql

To recreate it, do:

cat dump.sql | sqlite3 my.db