Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET bkdir=d:\manualbackup\data
- SET SAVEDATA="%bkdir%\mysql.7z"
- SET mysqldir=c:\mysql\bin
- SET mysqluser=root
- SET mysqlpassword=myrootpassword
- REM 7-zip executable path
- SET SEVENPATH="%PROGRAMFILES%\7-Zip\7z.exe"
- REM zipped file to save data
- SET ADDUP=a
- IF EXIST %SAVEDATA% SET ADDUP=u
- @REM Change to mysqldir
- CD %mysqldir%
- @REM dump database. This is all one line
- "%mysqldir%\mysqldump.exe" -u %mysqluser% -p%mysqlpassword% --opt --all-databases >"%bkdir%\backup.sql"
- %SEVENPATH% %ADDUP% -ms=off -pfuxedboost -t7z %SAVEDATA% "%bkdir%\backup.sql"
- del "%bkdir%\backup.sql"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement