mysql5.7管理

mysql 备份 http://jingyan.baidu.com/article/fec7a1e5effa331190b4e7ab.html

-------讲以下命令保存为bat-----------

set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"

if not exist "D:\MysqlBackUp" md "D:\MysqlBackUp"

if exist "D:\MysqlBackUp\mysql_%Ymd%.sql" del /q D:\MysqlBackUp\mysql_%Ymd%.sql

if exist "D:\MysqlBackUp\mysql_%Ymd%.zip" del /q D:\MysqlBackUp\mysql_%Ymd%.zip

"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe" -h localhost -P 3306 --all-databases -u root -p123456 --add-drop-table > "D:/MysqlBackUp/mysql_%Ymd%.sql" 
rar a  D:/MysqlBackUp/mysql_%Ymd%.zip  D:/MysqlBackUp/mysql_%Ymd%.sql

del /q D:\MysqlBackUp\mysql_%Ymd%.sql
echo OK!
------------pause---------------

注：复制rar压缩包中的Rar.exe 文件到C:\Windows 目录下否则无法完成压缩功能