Archive for the 'sqlite' Category

23
Sep
11

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




Blog Stats

  • 215,481 hits