Will give that a shot.
Thanks
Printable View
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...
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
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