Windows scheduled task settings MySQL automatic backup

Creating a BAT file

You need to put 7z.dll and 7z.exe in the bat's sibling directory and Mysqldump.exe these 3 files

Echo offCLSCD/D%~dp0REM===========configure (start) ==============Sethost=127.0.0.1SetUser=AdminSetpass=Configure your MySQL passwordSetDbname=the name of the database to be backed upREM===========configure (end) ==============REMSet-date-and-time-toymd-and-hisSet"ymd=%date:~,4%%date:~5,2%%date:~8,2%"Seth=% Time: ~0,2%SetH=%h: =0%Set"his=%h%%time:~3,2%%time:~6,2%"Echo%ymd%%his%REMMysql-dump-startmkdirsqlbakmysqldump-r-h%host%-p3306-u%user%-p%pass%%dbname%>sqlbak/%dbname%.sql7z a-txz Sqlbak/%dbname%_%ymd%%his%.xz sqlbak/%dbname%.SQLPause

Save the above to bat and then put the scheduled task settings in the Control Panel

Windows scheduled task settings MySQL automatic backup