Topic: I HAYW HOW GAY THE PREN
Anonymous A started this discussion 4 weeks ago #134,170
/
boof joined in and replied with this 4 weeks ago, 13 minutes later[^] [v] #1,429,156
@ECHO OFF
@SETLOCAL ENABLEEXTENSIONS
REM ffVacuumAll2.cmd v2 2017-10-19
REM Runs sqlite3 VACUUM command on all SQLite databases in the current folder
REM Just for safety we will not compact files with a Write-Ahead-Log remaining behind
REM Make backup of all databases prior to vacuuming
PUSHD "%~dp0"
MD SQLiteBackup >NUL:
COMPACT /C SQLiteBackup >NUL:
For %%F in ("*.sqlite") do (
IF NOT EXIST "%%~F-wal" (
copy /Y /B "%%~F" SQLiteBackup >NUL: 2>&1
IF ERRORLEVEL 0 (
echo Compacting "%%~F"
sqlite3 "%%~F" "VACUUM;" )
) ELSE echo Skipping "%%~F" because of existing Write-Ahead-Log
)
POPD
pause
@SETLOCAL ENABLEEXTENSIONS
REM ffVacuumAll2.cmd v2 2017-10-19
REM Runs sqlite3 VACUUM command on all SQLite databases in the current folder
REM Just for safety we will not compact files with a Write-Ahead-Log remaining behind
REM Make backup of all databases prior to vacuuming
PUSHD "%~dp0"
MD SQLiteBackup >NUL:
COMPACT /C SQLiteBackup >NUL:
For %%F in ("*.sqlite") do (
IF NOT EXIST "%%~F-wal" (
copy /Y /B "%%~F" SQLiteBackup >NUL: 2>&1
IF ERRORLEVEL 0 (
echo Compacting "%%~F"
sqlite3 "%%~F" "VACUUM;" )
) ELSE echo Skipping "%%~F" because of existing Write-Ahead-Log
)
POPD
pause
Anonymous A (OP) replied with this 4 weeks ago, 1 minute later, 15 minutes after the original post[^] [v] #1,429,157
Anonymous C joined in and replied with this 4 weeks ago, 57 minutes later, 1 hour after the original post[^] [v] #1,429,163
