Re: Dumping photos.db
- From: "Dotan Cohen" <dotancohen gmail com>
- To: "Stephane Delcroix" <stephane delcroix org>
- Cc: f-spot-list <f-spot-list gnome org>
- Subject: Re: Dumping photos.db
- Date: Fri, 12 Jan 2007 13:06:31 +0200
On 12/01/07, Stephane Delcroix <stephane delcroix org> wrote:
sqlite3 path/to/your/photos.db "SELECT id, name from tags" > tags
and so on
s
Thanks, Stephane. That gives me the values, deliminated by pipes.
While I could parse that, I'd rather have it output SQL, like the dump
command. Rereading my original message, I see that I didn't specify
that although I should have (I only used the term dump in the subject
line). Er, can I have it output SQL that I can insert into MySQL on
the server?
Dotan Cohen
http://technology-sleuth.com/technical_answer/what_are_the_advantages_of_lcd_monitors.html
http://lyricslist.com/lyrics/artist_albums/612/zion_i.html
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]