SQLite — Dump database

In order to dump a SQLite database you can use the following command:

sqlite database .dump > database.sql

To put the data into a SQLite database from a sql file use:

sqlite database < database.sql

摘自：http://notfaq.wordpress.com/2006/08/20/databasessql-sqlite-dump-database/