Role of .dump ?TABLE? in SQLite

Monika Arora

15y2.1kDatabases & DBA

Why we use .dump ?TABLE? in SQLite

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aarti15y ago
Accepted answer
Hi Monika,
do this step by step
step 1: need to create table named Cars
CREATE TABLE cars
(carid INTEGER NOT NULL,
color CHAR(25),
model VARCHAR(25),
PRIMARY KEY (carid),
UNIQUE (color)) ;

step 2: if you want to store your table in file use below

sqlite> .output cars.sql
step 3: to get backup of file
sqlite> .dump Cars
step 4: to quit
sqlite> .quit

Thanks.
please mark it as answer.
0
Vulpes15y ago
Monika,

The output you were getting from the command: .dump ?emp? is the sort of output you'd expect if you hadn't added any records to the table.

Assuming you have added some records, I'd try again with .dump emp

In other words, forget the question marks.
0
Aarti15y ago
Hi Monika,

Refer below link to learn more about SQLite

http://www.pantz.org/software/sqlite/sqlite_commands_and_general_usage.html
0
Monika Arora15y ago
Hi Vulpes. I have executed this command already from site which you have mentioned. I have used emp table so I have used this command: .dump ?emp? Its showing the following output which I m not able to understand.

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
0
Monika Arora15y ago
Hi Aarti, what is cars.sql here? Why you have used .sql with cars table? I have execute this statement but its not showing any result

0
Aarti15y ago
Hi Monika,

The .dump command shows us the SQL necessary to recreate the table.
```
sqlite> .output cars.sql
sqlite> .dump Cars



I hope it will help you.


Thanks.
```
0
Vulpes15y ago
There's a list of the 'dot' commands which can be used from the SQLite command line shell here:

http://www.sqlite.org/sqlite.html

As you'll see the .dump command converts the database into an ASCII text file.
0