Re: Upgrading sqlite database format

["Gabriel Burt" <gabriel burt gmail com>]

On 11/4/06, Hugo Vincent <hugo vincent gmail com> wrote:
> Is there any way to (semi-)automagically convert my old database to the new
> format? I really hope so!

cd ~/.gnome2/f-spot/
mv photos.db photos_sqlite2.db
sqlite photos_sqlite2.db .dump | sqlite3 photos.db

Note the first sqlite call in the last instruction is sqlite (which is
sqlite2 implicitly, so you must have it installed).

Gabriel