Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Library gone following restart

  1. #11
    Join Date
    Oct 2012
    Posts
    122

    Default

    Will give that a shot.
    Thanks

  2. #12
    Join Date
    Feb 2017
    Posts
    58

    Default

    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 06:11 PM.

  3. #13
    Join Date
    Sep 2009
    Posts
    2,413

    Default

    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

  4. #14
    Join Date
    Feb 2017
    Posts
    58

    Default

    Quote Originally Posted by Peter View Post
    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.
    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

  5. #15
    Join Date
    Jun 2012
    Posts
    555

    Default

    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

  6. #16
    Join Date
    Sep 2009
    Posts
    2,413

    Default

    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 09: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

Similar Threads

  1. Dlna continue from or restart
    By ahuy2703 in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 10-01-2018, 08:33 AM
  2. Dlna continue from or restart
    By srthomas in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 09-23-2013, 01:21 PM
  3. Need to restart since version update
    By HomerRamone in forum Mezzmo Questions and Support
    Replies: 2
    Last Post: 03-12-2013, 10:58 AM
  4. Movie restart
    By suriya25 in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 12-19-2012, 12:30 PM
  5. Wireless + WD TV Live - Keep having to restart Mezzmo service
    By Visor in forum Mezzmo Questions and Support
    Replies: 8
    Last Post: 11-18-2011, 08:52 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •