如何从 SQLite3 数据库文件转储 SQL
如果你有 SQLite3 数据库文件（通常文件扩展名为 .db）并且你想将其转储为 SQL 代码，你可以使用
dump_sqlite_db.sh
sqlite3 [database file] .dump例如：
sqlite3_dump_example.sh
$ sqlite3 /usr/share/command-not-found/commands.db .dump
[...]
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('packages',14669);
INSERT INTO sqlite_sequence VALUES('commands',47706);
CREATE INDEX idx_commands_command ON commands (command);
CREATE INDEX idx_packages_name ON packages (name);
COMMIT;缺少 sqlite3 可执行文件？
如果你没有 sqlite3 可执行文件，你可以使用以下命令安装
install_sqlite3.sh
sudo apt -y install sqlite3在 Ubuntu/Debian 系统上
If this post helped you, please consider buying me a coffee or donating via PayPal to support research & publishing of new posts on TechOverflow