1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| rem @echo off
Net use S: \\MON-SERVEUR:PORT\FTPServeur$ password /USER:*****\FTPServeur
REM set filename=OCS-MySQLDump_%date:~3,2%-%date:~0,2%-%date:~6,4%_%time:~0,2%h%time:~3,2%.sql
set filename=OCS-MySQLDump_%date:~3,2%-%date:~0,2%-%date:~6,4%_%time:~0,2%h%time:~3,2%.sql
REM Definition de l'emplacement de travail
set repdest=C:\xampp\mysql\bin
REM Sauvegarde + compression
"C:\xampp\mysql\bin\mysqldump.exe" -h localhost --user=root --password=***** --all-databases > "S: \OCS-MySQLDump_%date:~3,2%-%date:~0,2%-%date:~6,4%_%time:~0,2%h%time:~3,2%.sql"
"C:\xampp\mysql\bin\gzip.exe" -f9 "S: \OCS-MySQLDump_%date:~3,2%-%date:~0,2%-%date:~6,4%_%time:~0,2%h%time:~3,2%.sql"
Net use S: /delete |
Partager