之前安装了MySQL Server5.6,MySQL WorkBench5.2.47,备份数据库的时候,提示错误:
mysqldump Version Mismatch
mysqldump.exe is version 5.5.16,but the MySQL Server to be dumped has version 5.6.10-log.Because the version of mysqldump is older than the server,some features may not be backed up properly.
It is recommended you upgrade your local MySQL client programs, including mysqldump to a version equal to or newer than that of the target server.The path to the dump tool must then be set in Preferences -> Administrator -> Path to mysqldump Tool:
大概意思是,备份数据库用的那个文件版本太低了,要用高点的版本。
解决办法:
在MySQL Workbench里,点击菜单:Edit--Preferences
选择Administrator,里面第一项,Path to mysqldump Tool
找到MySQL安装目录,注意,不是WorkBench的安装目录哦,选择备份用的那个文件,然后ok确定就好了。