SQLite Forum

The .dump command accepts a table name as an optional argument.
It's not overly difficult to script it any way you like:

```sh
  for tbl in \
$(sqlite3 $db "SELECT name FROM sqlite_master WHERE type=='table' ORDER BY name")
  do
    sqlite3 $db ".dump $tbl"
  done >yourdumpfile
```

Hope this helps.

~~~
-- 
Regards,
Kees Nuyt
~~~