set host=127.0.0.1
set port=3306
set user=
set password=
set hour=%time:~0,2%
set hour=%hour: =0%
set backupdate=%date:~0,4%%date:~5,2%%date:~8,2%_%hour%%time:~3,2%%time:~6,2%
"C:\Program Files\MySQL\MySQL Server 5.7\bin"\mysqldump --opt --user=%user% --password=%password% --host=%host% --port=%port% --all-databases > E:\db_backup\%backupdate%.sql
"C:\Program Files\WinRAR\WinRAR" a E:\db_backup\%backupdate%.rar E:\db_backup\%backupdate%.sql
del E:\db_backup\%backupdate%.sql
20200611_213500.rar
