DJanGo wrote: > @ dasmueller: > its frustrating to see someone that has an idea realized that idea and > decides to share his idea even when that means he has a lot more to to > than just use his thing for his own purposes and some other jump on the > train and ask for impossible or senseless things... > > @pkfox: > I realized that there is some interest for an "offline collection > Dokumentation" and i decided > to re-animate my own way to solve this (cause in my private hours i am a > Linux User i cant just use your Tool - and cause of my ego i wont > *lol*) > > Even without knowing exactly what your doing - i may have a tip for you > and the guys that use your Tool. > > "My" way to get a offline Dokumentation of my collection just needs two > tables out of the library.db. > > > > - contributors - albums > > > > > I dont know which tables you use but instead of copying the whole > library.db (if someone has to cause using a headless dedicated lms > Server) > Should be simple as eg: > $lms_offline_db is my var for the filename under Windows it must be > something like %lms_offline_db% > rm is the same as del under *blows - > dont "dump" the same tables into your offline_db twice - deleting the > offline_db before the dump is the simplest way to solve this > > > Code: -------------------- > > > rm $lms_offline_db > sqlite3 /var/lib/squeezeboxserver/cache/library.db ".dump albums"|sqlite3 $lms_offline_db > sqlite3 /var/lib/squeezeboxserver/cache/library.db ".dump contributors"|sqlite3 $lms_offline_db > -------------------- > > > > the mimic from that is: > sqlite3 source_db ".dump contributors"|sqlite3 destination_db > > After that you end up with a smaller database file if you need to copy > that from your dedicated lms Server. > In my case the shortend library is just 2.8 MB instead of 118 MB. > > Feel free to adapt this idea and add the needed tables somewhere her > to others that might uses that.
Don't see the point all your doing is saving a bit of space which you can achieve by deleting the copy when you're done We can't stop here this is bat country. RIP Hunter S Thompson. ------------------------------------------------------------------------ pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
