---sqlite3数据库 整个数据库备份 C:>sqlite3 test.sqlite3 SQLite version 3.5.4 Enter ".help" for instructions sqlite> .output test.sqlite3.sql sqlite> .dump sqlite> .exit C:> sqlite3
---数据库 单个表备份 C:>sqlite3 test.sqlite3 SQLite version 3.5.4 Enter ".help" for instructions sqlite> .tables messages schema_info sqlite> .output test_messages.sqlite3.sql sqlite> .dump messages sqlite> .exit C:> sqlite3
---数据库 恢复,适合整库及单表 C:>sqlite3 new.sqlite3 SQLite version 3.5.4 Enter ".help" for instructions sqlite> .read test.sqlite3.sql sqlite> .exit C:>