How do I dump the data of some SQLite3 tables?
- by J. Pablo Fernández
How do I dump the data, and only the data, not the schema, of some SQLite3 tables of a database (not all the tables)?
The dump should be in SQL format, as it should be easily re-entered into the database latter and should be done from the command line. Something like
sqlite3 db .dump
but without dumping the schema and selecting which tables to dump.