Will give that a shot.
Thanks
Will give that a shot.
Thanks
I had some db corruption before where some playlist items would be blank (matching rules was not working), and to completely reset the db with 1000's of items would take too long to start over since I like to do manual updates.
it's a shame Mezzmo doesn't have a repair feature for the db maybe that would be something to add in the future, it seems like the log can detect errors just needs a way to fix the field or restore from previous backup...etc.
anyways I have had good luck doing this, you can try this but first make a backup for the database, shut down mezzmo server and close out mezzmo, if you have a linux machine handy copy the Mezzmo.db over to the linux pc and run this command.
sqlite3 Mezzmo.db ".dump" | sqlite3 MezzmoNew.db
Then copy MezzmoNew.db over to your windows computer mezzmo database folder and rename it to Mezzmo.db, this should of fixed any corruption , reopen mezzmo, and see how it looks.
there might be a windows port of sqlite3 (probably is) but since I have linux handy I never attempted to try anything else...
Last edited by odin; 11-22-2020 at 07:11 PM.
We considered adding a database repair feature but a repair can be hit or miss and there is no way to easily verify that all the data is complete after a repair.
Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
Twitter: https://twitter.com/conceiva_mezzmo
Web: http://www.mezzmo.com
True but that's the risk with any repair, I used Microsoft chkdsk before and it wiped out half my files trying to recover off a bad hdd , just add a few warnings tell users not to use it on in extreme cases, suggest restoring backup first...etc
Another useful feature might be an automated db backup setting (like crontab for db) with different levels of backup, ie do Full Backup (images , database..etc), Light Backup (just sql databases) - then with time settings for when to trigger it, with extra options like create full backup every month, and create a light backup every week ...etc
Might be something which could be added via the command line interface and then users could use the Windows Task Scheduler to schedule. Though backups are disruptive and stop streaming so I am not sure how many folks would want to schedule.
Jeff
You could possibly use the Windows task scheduler and a batch file to copy the Mezzmo.db file to a backup folder periodically. The batch file could contain:
mkdir g:\mymezzmobackups
COPY g:\mymezzmodb\Mezzmo.db g:\mymezzmobackups\Mezzmo_%time:~0,2%%time:~3,2%%t ime:~6,2%_%date:~-10,2%%date:~-7,2%%date:~-4,4%.db
You could also add in a 'net stop Mezzmo' before the backup and 'net start Mezzmo' after the backup to stop the server and restart it afterward. This would only apply if the server is running as a service
net stop Mezzmo
mkdir g:\mymezzmobackups
COPY g:\mymezzmodb\Mezzmo.db g:\mymezzmobackups\Mezzmo_%time:~0,2%%time:~3,2%%t ime:~6,2%_%date:~-10,2%%date:~-7,2%%date:~-4,4%.db
net start Mezzmo
Last edited by Peter; 11-25-2020 at 10:04 AM.
Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
Twitter: https://twitter.com/conceiva_mezzmo
Web: http://www.mezzmo.com
Bookmarks