Reply to thread

Message

<blockquote data-quote="RoChess" data-source="post: 1014075" data-attributes="member: 18896">Finally found some time to scrub script, so here goes:[collapse][code=WinBatch]@Echo Off:::: Auto backup/restore MediaPortal databases based on integrity check.:::: Author&nbsp; » RoChess:: Updated » July 19th 2013::SET BACKUP=AutoBackupSET MEPO_PATH=Team MediaPortal\MediaPortal\databaseIF EXIST &quot;%AllUsersProfile%\Application Data\%MEPO_PATH%\*.db3&quot; SET DB3_PATH=%AllUsersProfile%\Application Data\%MEPO_PATH%IF EXIST &quot;%AllUsersProfile%\%MEPO_PATH%\*.db3&quot;&nbsp;&nbsp; SET DB3_PATH=%AllUsersProfile%\%MEPO_PATH%IF &quot;%DB3_PATH%&quot;==&quot;&quot; GOTO Error_MePoIF NOT EXIST &quot;%~dp0\sqlite3.exe&quot; GOTO Error_SQLite:: Check to make sure MediaPortal is not still running::tasklist | find /i /c &quot;MediaPortal.exe&quot; &gt;nul &amp;&amp;goto MediaPortalRunningtasklist | find /i /c &quot;PluginConfigLoader.exe&quot; &gt;nul &amp;&amp;goto MediaPortalRunningtasklist | find /i /c &quot;Moving Pictures Config.exe&quot; &gt;nul &amp;&amp;goto MediaPortalRunningtasklist | find /i /c &quot;MP-TVSeries-Configuration.exe&quot; &gt;nul &amp;&amp;goto MediaPortalRunningecho Auto Backup/Restore STARTED (%DATE% -- %TIME%) &gt;&quot;%~dpn0.log&quot;echo.&gt;&gt;&quot;%~dpn0.log&quot;CD /D &quot;%DB3_PATH%&quot;FOR %%I IN (*.db3) DO (CALL:checkSQLite &quot;%%I&quot;)echo.&gt;&gt;&quot;%~dpn0.log&quot;echo Auto Backup/Restore FINISHED (%DATE% -- %TIME%) &gt;&gt;&quot;%~dpn0.log&quot;:LaunchMediaPortal:: Locating MediaPortal folder::IF EXIST &quot;%ProgramFiles%\Team MediaPortal\MediaPortal\MediaPortal.exe&quot;&nbsp; (&nbsp; start &quot;MediaPortal&quot; &quot;%ProgramFiles%\Team MediaPortal\MediaPortal\MediaPortal.exe&quot;) ELSE (&nbsp; IF EXIST &quot;%ProgramFiles(x86)%\Team MediaPortal\MediaPortal\MediaPortal.exe&quot;&nbsp; (&nbsp;&nbsp; start &quot;MediaPortal&quot; &quot;%ProgramFiles(x86)%\Team MediaPortal\MediaPortal\MediaPortal.exe&quot;&nbsp; ) ELSE (&nbsp;&nbsp; Goto MediaPortalNotFound&nbsp; ))GOTO:EOF:checkSQLiteIF %~z1 EQU 0 (&nbsp; echo&nbsp; &nbsp; Aborting: &quot;%~nx1&quot; is ZERO bytes&nbsp; echo&nbsp; &nbsp; Aborting: &quot;%~nx1&quot; is ZERO bytes &gt;&gt;&quot;%~dpn0.log&quot;&nbsp; GOTO:EOF)SET Pass=Noecho PRAGMA integrity_check; | &quot;%~dp0\sqlite3.exe&quot; &quot;%~dpf1&quot; | find /c &quot;ok&quot; &gt; nul &amp;&amp;SET Pass=YesIF &quot;%Pass%&quot;==&quot;Yes&quot; (&nbsp; echo&nbsp; &nbsp; Updating backup for: &quot;%~nx1&quot;&nbsp; echo&nbsp; &nbsp; Updating backup for: &quot;%~nx1&quot; &gt;&gt;&quot;%~dpn0.log&quot;&nbsp; xcopy &quot;%DB3_PATH%\%~nx1&quot; &quot;%DB3_PATH%\%BACKUP%\&quot; /I /C /D /Y /Q &gt;nul)IF &quot;%Pass%&quot;==&quot;No&quot; (&nbsp; echo&nbsp; &nbsp; ERROR: DATABASE CORRUPT!&nbsp; IF NOT EXIST &quot;%DB3_PATH%\%BACKUP%\%~nx1&quot; (&nbsp;&nbsp; echo&nbsp; &nbsp;&nbsp; - No backup exists for: &quot;%~nx1&quot;&nbsp;&nbsp; echo&nbsp; &nbsp;&nbsp; - No backup exists for: &quot;%~nx1&quot; &gt;&gt;&quot;%~dpn0.log&quot;&nbsp; )&nbsp; IF EXIST &quot;%DB3_PATH%\%BACKUP%\%~nx1&quot; (&nbsp;&nbsp; echo&nbsp; &nbsp;&nbsp; - Restoring last-known good backup for: &quot;%~nx1&quot;&nbsp;&nbsp; echo&nbsp; &nbsp;&nbsp; - Restoring last-known good backup for: &quot;%~nx1&quot; &gt;&gt;&quot;%~dpn0.log&quot;&nbsp;&nbsp; xcopy &quot;%DB3_PATH%\%BACKUP%\%~nx1&quot; &quot;%DB3_PATH%\&quot; /I /C /Y /Q &gt;nul&nbsp; ))GOTO:EOF:MediaPortalRunningecho&nbsp;&nbsp; WARNING: MediaPortal is still running!!echo.echo&nbsp; &nbsp;&nbsp; MediaPortal and/or Configuration tools are still active.echo&nbsp; &nbsp;&nbsp; Try it again later, after giving it more time to finish.GOTO ErrorDelay:MediaPortalNotFoundecho&nbsp;&nbsp; WARNING: MediaPortal *NOT* Found!!echo.echo&nbsp; &nbsp;&nbsp; Unable to locate MediaPortal in the default location.echo&nbsp; &nbsp;&nbsp; Please adjust this script manually to use your custom folder.goto ErrorDelay:Error_MePoecho&nbsp;&nbsp; ABORTING: MediaPortal databases not foundecho.echo&nbsp; &nbsp;&nbsp; Nothing to do, please verify your MediaPortal installation.GOTO ErrorDelay:Error_SQLiteecho&nbsp;&nbsp; ABORTING: SQLite.exe command-line tool missing!echo.echo&nbsp; &nbsp;&nbsp; Download binary shell for Windows from: [URL]http://www.sqlite.org/download.html[/URL]echo&nbsp; &nbsp;&nbsp; Unzip and copy sqlite3.exe to:echo.echo&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot;%~dp0&quot;GOTO ErrorDelay:ErrorDelayecho.echo&nbsp;&nbsp; This window will self-destruct in a few seconds.echo.ping 1.1 -n 1 -w 5000 &gt;nulGOTO:EOF[/code][/collapse]To make it easier, I've attached script+sqlite3.exe in a ZIP file.Function:- It will use sqlite3.exe tool to verify all the DB3 databases did not go corrupt.- If DB3 passes check, it will make a fresh backup.- If check fails, it will auto-recover last-known good backup.- After it backed-up/restored all the databases, it will launch MediaPortal (it also does a check to make sure MePo is not running)Use this script to replace the method in which you normally launch MediaPortal.</blockquote>

[QUOTE="RoChess, post: 1014075, member: 18896"] Finally found some time to scrub script, so here goes: [collapse] [code=WinBatch]@Echo Off :: :: Auto backup/restore MediaPortal databases based on integrity check. :: :: Author » RoChess :: Updated » July 19th 2013 :: SET BACKUP=AutoBackup SET MEPO_PATH=Team MediaPortal\MediaPortal\database IF EXIST "%AllUsersProfile%\Application Data\%MEPO_PATH%\*.db3" SET DB3_PATH=%AllUsersProfile%\Application Data\%MEPO_PATH% IF EXIST "%AllUsersProfile%\%MEPO_PATH%\*.db3" SET DB3_PATH=%AllUsersProfile%\%MEPO_PATH% IF "%DB3_PATH%"=="" GOTO Error_MePo IF NOT EXIST "%~dp0\sqlite3.exe" GOTO Error_SQLite :: Check to make sure MediaPortal is not still running :: tasklist | find /i /c "MediaPortal.exe" >nul &&goto MediaPortalRunning tasklist | find /i /c "PluginConfigLoader.exe" >nul &&goto MediaPortalRunning tasklist | find /i /c "Moving Pictures Config.exe" >nul &&goto MediaPortalRunning tasklist | find /i /c "MP-TVSeries-Configuration.exe" >nul &&goto MediaPortalRunning echo Auto Backup/Restore STARTED (%DATE% -- %TIME%) >"%~dpn0.log" echo.>>"%~dpn0.log" CD /D "%DB3_PATH%" FOR %%I IN (*.db3) DO ( CALL:checkSQLite "%%I" ) echo.>>"%~dpn0.log" echo Auto Backup/Restore FINISHED (%DATE% -- %TIME%) >>"%~dpn0.log" :LaunchMediaPortal :: Locating MediaPortal folder :: IF EXIST "%ProgramFiles%\Team MediaPortal\MediaPortal\MediaPortal.exe" ( start "MediaPortal" "%ProgramFiles%\Team MediaPortal\MediaPortal\MediaPortal.exe" ) ELSE ( IF EXIST "%ProgramFiles(x86)%\Team MediaPortal\MediaPortal\MediaPortal.exe" ( start "MediaPortal" "%ProgramFiles(x86)%\Team MediaPortal\MediaPortal\MediaPortal.exe" ) ELSE ( Goto MediaPortalNotFound ) ) GOTO:EOF :checkSQLite IF %~z1 EQU 0 ( echo Aborting: "%~nx1" is ZERO bytes echo Aborting: "%~nx1" is ZERO bytes >>"%~dpn0.log" GOTO:EOF ) SET Pass=No echo PRAGMA integrity_check; | "%~dp0\sqlite3.exe" "%~dpf1" | find /c "ok" > nul &&SET Pass=Yes IF "%Pass%"=="Yes" ( echo Updating backup for: "%~nx1" echo Updating backup for: "%~nx1" >>"%~dpn0.log" xcopy "%DB3_PATH%\%~nx1" "%DB3_PATH%\%BACKUP%\" /I /C /D /Y /Q >nul ) IF "%Pass%"=="No" ( echo ERROR: DATABASE CORRUPT! IF NOT EXIST "%DB3_PATH%\%BACKUP%\%~nx1" ( echo - No backup exists for: "%~nx1" echo - No backup exists for: "%~nx1" >>"%~dpn0.log" ) IF EXIST "%DB3_PATH%\%BACKUP%\%~nx1" ( echo - Restoring last-known good backup for: "%~nx1" echo - Restoring last-known good backup for: "%~nx1" >>"%~dpn0.log" xcopy "%DB3_PATH%\%BACKUP%\%~nx1" "%DB3_PATH%\" /I /C /Y /Q >nul ) ) GOTO:EOF :MediaPortalRunning echo WARNING: MediaPortal is still running!! echo. echo MediaPortal and/or Configuration tools are still active. echo Try it again later, after giving it more time to finish. GOTO ErrorDelay :MediaPortalNotFound echo WARNING: MediaPortal *NOT* Found!! echo. echo Unable to locate MediaPortal in the default location. echo Please adjust this script manually to use your custom folder. goto ErrorDelay :Error_MePo echo ABORTING: MediaPortal databases not found echo. echo Nothing to do, please verify your MediaPortal installation. GOTO ErrorDelay :Error_SQLite echo ABORTING: SQLite.exe command-line tool missing! echo. echo Download binary shell for Windows from: [URL]http://www.sqlite.org/download.html[/URL] echo Unzip and copy sqlite3.exe to: echo. echo "%~dp0" GOTO ErrorDelay :ErrorDelay echo. echo This window will self-destruct in a few seconds. echo. ping 1.1 -n 1 -w 5000 >nul GOTO:EOF [/code][/collapse] To make it easier, I've attached script+sqlite3.exe in a ZIP file. Function: - It will use sqlite3.exe tool to verify all the DB3 databases did not go corrupt. - If DB3 passes check, it will make a fresh backup. - If check fails, it will auto-recover last-known good backup. - After it backed-up/restored all the databases, it will launch MediaPortal (it also does a check to make sure MePo is not running) Use this script to replace the method in which you normally launch MediaPortal. [/QUOTE]

Verification