sqlite3 .dump函数不保存文件(sqlite3 .dump function not saving file)

sqlite3 .dump函数不保存文件(sqlite3 .dump function not saving file)

我试图将数据库转储到文本文件，我使用这个语句： .dump | sqlite3 /Users/riceje7/Library/Application\ Support/Firefox/Profiles/4pixicxh.default/downloads.sqlite | gzip -c >database.dump.gz .dump | sqlite3 /Users/riceje7/Library/Application\ Support/Firefox/Profiles/4pixicxh.default/downloads.sqlite | gzip -c >database.dump.gz .dump | sqlite3 /Users/riceje7/Library/Application\ Support/Firefox/Profiles/4pixicxh.default/downloads.sqlite | gzip -c >database.dump.gz 。 我在终端中获得了begin transaction和commit语句，但该文件从未在我的计算机上保存。 有谁知道我做错了什么以及我怎么能让它发挥作用？

I am trying to dump a database to a text file, I am using this statement: .dump | sqlite3 /Users/riceje7/Library/Application\ Support/Firefox/Profiles/4pixicxh.default/downloads.sqlite | gzip -c >database.dump.gz. I get a begin transaction and commit statement in the terminal but the file never saves anywhere on my computer. Does anyone know what I am doing wrong and how i can get this to work?

最满意答案

使用以下语法：

sqlite3 /Users/riceje7/Library/Application/Support/Firefox/Profiles/4pixicxh.default/downloads.sqlite .dump | gzip -c >database.dump.gz

figured it out...the file i was trying to access was a protected file, all i had to do was copy the file to another location and access it there. thanks for the answer though