Create dump file only from some SQLite tables

Asked Jan 20 '16 at 07:36

Active Jan 20 '16 at 08:51

Viewed 99 times

In my SQLite database, I got 10 tables which I want to create dump file only from three of them. I tired some of the answers from How do I dump the data of some SQLite3 tables :

sqlite> AM.db ".dump 'table1' 'table2' 'table3'"

But I get:

Usage: .dump ?LIKE-PATTERN?

I get the same error trying:

sqlite> .open AM.db 
sqlite> .dump 'table1' 'table2' 'table3'

How can I create the dump file only from some tables of my database?

Edit

I also tried the command CL closed the question as duplicate for:

.mode insert <table1> <table2> <table3>
.out file.sql 
select * from table1;
select * from table2;
select * from table3;

But it just create a dump with Insert command and not Drop Table If exists or Create commands.

edited May 23 '17 at 10:27

Community

asked Jan 20 '16 at 07:36

Ghasem

The highes-voted question shows how to do this with `.mode insert`. – CL. Jan 20 '16 at 08:43
@CL. I tried that and updated my question. – Ghasem Jan 20 '16 at 08:51
That's what `.schema` is for. An none of these commands supports multiple table names. – CL. Jan 20 '16 at 08:54
@CL. There's no `.schema` mentioned in that question – Ghasem Jan 20 '16 at 09:05
\*clickety click\* But of course there is. ☺ – CL. Jan 20 '16 at 09:08
@CL. I have no idea what that means! – Ghasem Jan 20 '16 at 09:28
[Look again](http://stackoverflow.com/a/7526055/11654). – CL. Jan 20 '16 at 11:49

0 Answers0