天天看点

mysql dump 版本错误,mysqlworkbench在导出数据库时给出版本错误

mysql dump 版本错误,mysqlworkbench在导出数据库时给出版本错误

When I try to export my database through MySQL Workbench remotely from localserver,

I am getting some below version error:

mysqldump Version Mismatch [Content] 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

I am trying to find a solution - I searched for solution on google but couldn't find a good answer to solve the issue.

Does anyone know, how to fix this issue in MySQL Workbench?

解决方案

Go to Edit - Preferences - Administrator - Path to Mysqldumptool: (look for file mysqldump.exe in your MySQL Server instalation folder (it could be: mysql/bin/) then click it and ok), after that try to do the backup.