Reply to thread

Message

<blockquote data-quote="RoChess" data-source="post: 920019" data-attributes="member: 18896">And next time make a backup <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />&nbsp;There are plugins that will do it for you, or you can use your own method. I launch MediaPortal via a batch-script to make sure it doesn't launch again when it is already running (concurrent RDP), and I've added a verification and backup method to it. To verify the databases did not corrupt I use the open source commandline util from the SQLite project via:&nbsp;[code]echo pragma integrity_check; | sqlite3.exe &quot;%~dpf1&quot; | find /c &quot;ok&quot; &amp;&amp;SET Pass=YesIF &quot;%Pass%&quot;==&quot;Yes&quot; (&nbsp; ::DB3 good)IF &quot;%Pass%&quot;==&quot;No&quot; (&nbsp; ::DB3 corrupt)[/code]&nbsp;And if it passes it will become the new backup and if it fails the previous backup file is restored. Was forced to do this because the FanartHandler database tends to corrupt on occasion for me. The script also checks to see if it is a new month and then makes an additional backup. The entire script is very specific for my usage, but if there is interest I will clean it up so others can use it.</blockquote>

[QUOTE="RoChess, post: 920019, member: 18896"] And next time make a backup :) There are plugins that will do it for you, or you can use your own method. I launch MediaPortal via a batch-script to make sure it doesn't launch again when it is already running (concurrent RDP), and I've added a verification and backup method to it. To verify the databases did not corrupt I use the open source commandline util from the SQLite project via: [code] echo pragma integrity_check; | sqlite3.exe "%~dpf1" | find /c "ok" &&SET Pass=Yes IF "%Pass%"=="Yes" ( ::DB3 good ) IF "%Pass%"=="No" ( ::DB3 corrupt ) [/code] And if it passes it will become the new backup and if it fails the previous backup file is restored. Was forced to do this because the FanartHandler database tends to corrupt on occasion for me. The script also checks to see if it is a new month and then makes an additional backup. The entire script is very specific for my usage, but if there is interest I will clean it up so others can use it. [/QUOTE]

Verification