Différences
Ci-dessous, les différences entre deux révisions de la page.
sysadmin:mysqldump_windows [2019/05/14 14:40] james créée |
sysadmin:mysqldump_windows [2019/05/15 15:07] (Version actuelle) james [Ecriture du script de sauvegarde] ajout compression cab ou 7zip |
||
---|---|---|---|
Ligne 36: | Ligne 36: | ||
SET MINUTE=%time:~3,2% | SET MINUTE=%time:~3,2% | ||
SET SECOND=%time:~-5,2% | SET SECOND=%time:~-5,2% | ||
- | + | ||
IF "%time:~0,1%"==" " SET HEURE=0%HEURE:~1,1% | IF "%time:~0,1%"==" " SET HEURE=0%HEURE:~1,1% | ||
- | + | ||
SET REPERTOIR=D:\SauvegardeMysql\ | SET REPERTOIR=D:\SauvegardeMysql\ | ||
- | + | ||
SET FICHIER=%REPERTOIR%%ANNEE%_%MOIS%\Sauvegarde_mysql_du_%JOUR%_%MOIS%_%ANNEE%_a_%HEURE%_%MINUTE%.sql | SET FICHIER=%REPERTOIR%%ANNEE%_%MOIS%\Sauvegarde_mysql_du_%JOUR%_%MOIS%_%ANNEE%_a_%HEURE%_%MINUTE%.sql | ||
- | + | ||
IF NOT exist "%REPERTOIR%%ANNEE%_%MOIS%" md "%REPERTOIR%%ANNEE%_%MOIS%" | IF NOT exist "%REPERTOIR%%ANNEE%_%MOIS%" md "%REPERTOIR%%ANNEE%_%MOIS%" | ||
- | + | ||
+ | REM do the actual dump | ||
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump" -u root --opt iobeya -h localhost > %FICHIER% | "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump" -u root --opt iobeya -h localhost > %FICHIER% | ||
+ | REM Compress DB dump file into CAB file (use "EXPAND file.cab" to decompress). | ||
+ | REM makecab / expand command is available on all windows versions and compression is claimed to be better than zip | ||
+ | REM MAKECAB "%FICHIER%" "%FICHIER%.cab" | ||
+ | REM or we just use 7zip since it works better :p | ||
+ | "C:\Program Files\7-Zip\7z.exe" a -t7z %FICHIER%.7z %FICHIER% | ||
+ | |||
+ | REM Delete uncompressed DB dump file if comprssion is fine | ||
+ | if %ERRORLEVEL% EQU 0 DEL /q /f "%FICHIER%" | ||
+ | |||
+ | REM remove backups older than 2 months old | ||
set /a m=%date:~3,2%-2 | set /a m=%date:~3,2%-2 | ||
if %m% LSS 10 set m=0%m% | if %m% LSS 10 set m=0%m% | ||
Ligne 52: | Ligne 63: | ||
rmdir "%REPERTOIR%%a%_%m%" /s /q | rmdir "%REPERTOIR%%a%_%m%" /s /q | ||
+ | |||
</code> | </code> | ||
<note>Vous devez bien sur également adapter les chemins de sauvegarde et de mysqldump</note> | <note>Vous devez bien sur également adapter les chemins de sauvegarde et de mysqldump</note> |