Re: Dumping photos.db

[Stephane Delcroix <stephane delcroix org>]

sqlite3 path/to/your/photos.db "SELECT id, name from tags" > tags

and so on

s


On Fri, 2007-01-12 at 12:08 +0200, Dotan Cohen wrote:
> The birth of my daughter has inspired my to get a photo album up on my
> site. To do that, I must export some info from F-Spot's database. I
> have STFW for a few hours now and can't seem to come up with the
> method of exporting SQL from the photos.db database. Note that sqlite
> does NOT recognize the photo.db database, so I am using sqlite3.
> 
> I want to output to a text file these SQL commands:
> 
> SELECT id, name FROM tags;
> SELECT id, time, directory_path, name FROM photos;
> SELECT photo_id, tag_id FROM photo_tags;
> 
> Please, how on Earth do I do that?!? Thanks!
> 
> Dotan Cohen
> 
> http://lyricslist.com/lyrics/artist_albums/273/jackson_michael.html
> http://what-is-what.com/what_is/electromagnet.html
> _______________________________________________
> F-spot-list mailing list
> F-spot-list gnome org
> http://mail.gnome.org/mailman/listinfo/f-spot-list
> 
-- 
Stephane Delcroix
stephane delcroix org