Re: [darktable-user] darktable 2.0.x library
* Sascha Oleszczuk [09-23-16 07:11]: > thx. Do you perform the backup in case of a db dump? or another tool? > In my case the dump is a lot smaller as the db. > Sascha > > 2016-09-21 16:50 GMT+02:00 Patrick Shanahan : > > > * Sascha Oleszczuk [09-21-16 09:33]: > > > Hi All, > > > > > > are there any recommendation regarding the sqlite db (library). > > > > > > 1.) do you perform a backup? > > > > daily > > > > > 2.) is there a critical amount of images it can manage? > > > > I have +80k > > > > > or do you import all your images > > > > yes > > > > >and never perform a cleanup? > > > > I occasionally run: > > sqlite3 ./library.db "VACUUM;" > > and > > sqlite3 ./library.db "PRAGMA integrity_check" > > but on a lib copy, just-in-case > > > > -- > > (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri > > http://en.opensuse.orgopenSUSE Community Memberfacebook/ptilopteri > > http://wahoo.no-ip.orgPhoto Album: http://wahoo.no-ip.org/gallery2 > > Registered Linux User #207535@ http://linuxcounter.net > > > > > > darktable user mailing list > > to unsubscribe send a mail to darktable-user+unsubscribe@ > > lists.darktable.org > > > > > > > darktable user mailing list > to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org i backup my "system" daily. -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.orgopenSUSE Community Memberfacebook/ptilopteri http://wahoo.no-ip.orgPhoto Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535@ http://linuxcounter.net darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org
Re: [darktable-user] darktable 2.0.x library
thx. Do you perform the backup in case of a db dump? or another tool? In my case the dump is a lot smaller as the db. Sascha 2016-09-21 16:50 GMT+02:00 Patrick Shanahan : > * Sascha Oleszczuk [09-21-16 09:33]: > > Hi All, > > > > are there any recommendation regarding the sqlite db (library). > > > > 1.) do you perform a backup? > > daily > > > 2.) is there a critical amount of images it can manage? > > I have +80k > > > or do you import all your images > > yes > > >and never perform a cleanup? > > I occasionally run: > sqlite3 ./library.db "VACUUM;" > and > sqlite3 ./library.db "PRAGMA integrity_check" > but on a lib copy, just-in-case > > -- > (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri > http://en.opensuse.orgopenSUSE Community Memberfacebook/ptilopteri > http://wahoo.no-ip.orgPhoto Album: http://wahoo.no-ip.org/gallery2 > Registered Linux User #207535@ http://linuxcounter.net > > > darktable user mailing list > to unsubscribe send a mail to darktable-user+unsubscribe@ > lists.darktable.org > > darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org
Re: [darktable-user] darktable 2.0.x library
* Sascha Oleszczuk [09-21-16 09:33]: > Hi All, > > are there any recommendation regarding the sqlite db (library). > > 1.) do you perform a backup? daily > 2.) is there a critical amount of images it can manage? I have +80k > or do you import all your images yes >and never perform a cleanup? I occasionally run: sqlite3 ./library.db "VACUUM;" and sqlite3 ./library.db "PRAGMA integrity_check" but on a lib copy, just-in-case -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.orgopenSUSE Community Memberfacebook/ptilopteri http://wahoo.no-ip.orgPhoto Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535@ http://linuxcounter.net darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org
