mysqlworkbench在导出数据库时给出版本错误 [英] mysqlworkbench giving version error on exporting database

问题描述

当我尝试通过MySQL Workbench从localserver远程导出数据库时，

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

我收到一些低于版本的错误:

I am getting some below version error:

mysqldump版本不匹配[内容] mysqldump.exe的版本为5.5.16，但是要转储的MySQL Server的版本为5.6.10-log.由于mysqldump的版本早于服务器，因此某些功能可能无法正确备份.建议您将本地MySQL客户端程序(包括mysqldump)升级到等于或高于目标服务器的版本.然后必须在首选项"->管理员"->"mysqldump工具的路径"中设置转储工具的路径

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

我正在寻找解决方案-我在Google上搜索了解决方案，但找不到解决该问题的好答案.

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

有人知道如何在MySQL Workbench中解决此问题吗?

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

推荐答案

转到编辑"惯用选项"管理员""Mysqldumptool的路径:(在MySQL Server安装文件夹中查找mysqldump.exe文件(可能是:mysql/bin /)，然后单击它并确定)，然后尝试进行备份.

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.

这篇关于mysqlworkbench在导出数据库时给出版本错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！