Smartphone

mysql dump and save batch

mysql dump and save batch

mysql dump and save with a batch file. Its quite old but works.

SET bkdir=d:manualbackupdata
SET SAVEDATA="%bkdir%mysql.7z"
SET mysqldir=c:mysql in
SET mysqluser=root
SET mysqlpassword=pass

REM 7-zip executable path
SET SEVENPATH="%PROGRAMFILES%7-Zip7z.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% ackup.sql"



%SEVENPATH% %ADDUP% -ms=off -pfuxedboost -t7z  %SAVEDATA% "%bkdir% ackup.sql"

del "%bkdir% ackup.sql"

visit link download