How to dump your database into a csv (unix/linux/maybe os-x)

Information and Tutorials on features in Mylar and how to use it
Post Reply
bmfrosty
Posts: 14
Joined: Wed May 07, 2014 2:12 am

How to dump your database into a csv (unix/linux/maybe os-x)

Post by bmfrosty »

You can vary this quite a bit to suit what you're looking for, but I recently used it to find database entries that showed a release date of 0000-00-00.

Here's the command line:

Code: Select all

sqlite3 ~/mylar/mylar.db "select * from issues where ReleaseDate is '0000-00-00' ;" | sed -e s/\|/\,/g > missing.csv
You'll need to modify it to match the location of your database and a custom filename.
Post Reply