how we can save database created in sqlite3

Question

I am new to database. I am trying to create a database and table in it. but unable to save and open again after exiting from sqlite. I am using sqlite3 3.6.20 on centOS, when i will enter following command

.save ex1.db or .open ex1.db 

it will print following error message.

Error: unknown command or invalid arguments:  "save". Enter ".help" for help Error: unknown command or invalid arguments:  "open". Enter ".help" for help 

and when Print .help it wont show any command related to save and open existing database. thanks in advance.

Answer 1

I am trying to create a database and table in it. but unable to save and open again after exiting from sqlite.

You don't need to save. Each transaction writes to disk. (More or less.)

To create the database "test.sl3", you can do this. (From the command line. Programs work about the same way.)

$ sqlite3 test.sl3 SQLite version 3.8.7.2 2014-11-18 20:57:56 Enter ".help" for usage hints. sqlite> create table test (test_id integer primary key); sqlite> insert into test values (1); sqlite> select * from test; 1 .quit 

No .save. Now load the database again.

$ sqlite3 test.sl3 SQLite version 3.8.7.2 2014-11-18 20:57:56 Enter ".help" for usage hints. sqlite> select * from test; 1 

The data is still there.

Answer 2

You're supposed to provide a filename as an argument for the .save command, e.g.:

sqlite> .save ex1.db 

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