Linux – How to dump sqlite database to ascii

linuxsqlite

For some reason Firefox won't let me see more than 1 month of history, despite I have set to to remember for 90 days.

places.sqlite is 18MB so I would like to dump the content of it, and see if I can find the missing history.

Does anyone know how to dump/export to a flat ascii file?

Best Answer

Instead of using a flat ASCII file, you may also find using a tool such as SQLite Manager useful to browse or edit your SQLite file. (It can run either as a Firefox add-on or as a standalone XUL application.)

Related Solutions

Get sqlite error, “unable to open database file”

Aha, just stumbled across an article explaining this. Also Django have info on their NewbieMistakes page.

The solution is to make sure the directory containing the database file also has write access allowed to the process.

In my case, running this command fixed the problem:

sudo chown www-data .

Linux Bash – How to Sort du -h Output by Size

As of GNU coreutils 7.5 released in August 2009, sort allows a -h parameter, which allows numeric suffixes of the kind produced by du -h:

du -hs * | sort -h

If you are using a sort that does not support -h, you can install GNU Coreutils. E.g. on an older Mac OS X:

brew install coreutils
du -hs * | gsort -h

From sort manual:

-h, --human-numeric-sort compare human readable numbers (e.g., 2K 1G)

Best Answer

Related Solutions

Get sqlite error, “unable to open database file”

Linux Bash – How to Sort du -h Output by Size

Related Topic