php mysqlworkbench 在导出数据库时给出版本错误

mysqlworkbench giving version error on exporting database

提问by Sizzling Code

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

当我尝试从本地服务器通过 MySQL Workbench 远程导出我的数据库时，

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

mysqldump Version Mismatch [Content] mysqldump.exe 是 5.5.16 版本，但是要转储的 MySQL Server 是 5.6.10-log 版本。由于 mysqldump 的版本比服务器旧，某些功能可能无法正确备份。建议您将本地 MySQL 客户端程序，包括 mysqldump 升级到与目标服务器相同或更高的版本。然后必须在 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.

我正在努力寻找解决方案 - 我在 google 上搜索了解决方案，但找不到解决问题的好答案。

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

有谁知道，如何在 MySQL Workbench 中解决这个问题？

回答by Gustavo

Go to: Edit-> Preferences-> Administrator-> Path to Mysqldumptool:
Look for file mysqldump.exein your MySQL Server installation folder (it could be: mysql/bin/). Then click it, and OK. After that try to do the backup.

转到：Edit-> Preferences-> Administrator-> Path to Mysqldumptool：在 MySQL Server 安装文件夹中
查找mysqldump.exe文件（可能是：）mysql/bin/。然后单击它，然后OK。之后尝试进行备份。

回答by Akaal

Fortunately, although not obvious, there is a fairly straightforward solution. You just need to update the mysqldump.exe. The up to date version of the .exefile can be found in. To solve the issue just go to Edit->Preferences->Administrator, and browse the following path

幸运的是，虽然不是很明显，但有一个相当简单的解决方案。您只需要更新mysqldump.exe. 该.exe文件的最新版本可以在 中找到。要解决该问题，只需转到Edit->Preferences->Administrator，然后浏览以下路径

C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe

grab this file and replace it at the Path to mysqldump tooltextbox

获取此文件并在Path to mysqldump tool文本框中替换它

There may be the following path is set before the above mentioned before, so just replace it with the newer one

前面提到的可能是下面的路径设置了，所以用新的替换就行了

C:\Program Files\MySQL\MySQL Workbench CE 5.2.47\mysqldump.exe

The paths may be slightly different for you, but the solution remains the same. In some OS(64bit), there are two folders C:\Program Files (x86)\MySQLand C:\Program Files\MySQLBut you have to go for C:\Program Files\MySQLHope it will help :)

您的路径可能略有不同，但解决方案保持不变。在某些操作系统（64 位）中，有两个文件夹 C:\Program Files (x86)\MySQL， C:\Program Files\MySQL但你必须去寻找C:\Program Files\MySQL希望它会有所帮助:)

回答by evilReiko

In Linux-based like Ubuntu, Edit > Preferences... > Administration (tab), set "Path to mydqldump Tool" to /usr/bin/mysqldump(most likely by default that's where it suppose to be).

在基于 Linux 的 Ubuntu 中，编辑 > 首选项... > 管理（选项卡），将“mydqldump 工具的路径”设置为/usr/bin/mysqldump（默认情况下很可能就是它应该在的位置）。

If you're not sure, you can try to find where is the mysqldump located by running the following command in terminal:

如果您不确定，您可以尝试通过在终端中运行以下命令来查找 mysqldump 所在的位置：

locate mysqldump

回答by Mike Lischke

The message says you need a newer mysqldump tool. One that matches the server you want to dump from. So depending on the platform you are running get a copy of the mysqldump tool from a server installation that has a recent version. Each server comes with a mysqldump tool. So it should be easy to get a copy.

该消息说您需要更新的 mysqldump 工具。与您要从中转储的服务器相匹配的一个。因此，根据您运行的平台，从具有最新版本的服务器安装中获取 mysqldump 工具的副本。每个服务器都带有一个 mysqldump 工具。因此，获取副本应该很容易。

Put the tool in a location where it has a persistent home, but does not conflict with other instances, and point MySQL Workbench at it (as the message says).

将该工具放置在它有一个持久的家，但不与其他实例冲突的位置，并将 MySQL Workbench 指向它（如消息所述）。

回答by Vladimir Despotovic

On my Mac, (running latest Mac OS Sierra), I changed the path of mysqldump to /Applications/XAMPP/xamppfiles/bin/mysqldump, and that solved the problem. Previously, the path was set to a different version (older version) of mysqldump. So, you need to get the newest version of mysqldump.

在我的 Mac（运行最新的 Mac OS Sierra）上，我将 mysqldump 的路径更改为 /Applications/XAMPP/xamppfiles/bin/mysqldump，从而解决了问题。以前，该路径设置为 mysqldump 的不同版本（旧版本）。因此，您需要获取最新版本的 mysqldump。

回答by navid hernandez

I was trying to solve this issue with the default mysqldump using Edit > Preferences... > Administration (tab), and setting from /usr/bin/mysqldumpwhich did not work.

我试图用默认的 mysqldump 解决这个问题Edit > Preferences... > Administration (tab)，并且设置/usr/bin/mysqldump不起作用。

I saw that XAMPP server has a mysqldump file too which worked fine! Generally, you can find it in /opt/lampp/bin/mysqldump(for Debian and similar) so you can use this path in your preferences inside workbench.

我看到 XAMPP 服务器也有一个 mysqldump 文件，它运行良好！通常，您可以在/opt/lampp/bin/mysqldump（对于 Debian 和类似版本）中找到它，因此您可以在工作台内的首选项中使用此路径。

回答by vedant03p

This occurs when the version of your mysql workbench is different than that of your mysql server. Solution to this is to use mysqldump.exe having version same as that of your server for taking the export/dump. Steps :

当您的 mysql 工作台的版本与您的 mysql 服务器的版本不同时，就会发生这种情况。解决方案是使用与您的服务器版本相同的 mysqldump.exe 进行导出/转储。脚步 ：

1. Download the mysql zip of the same version as your server. (eg. mysql-5.7.25-winx64.zip)
2. Inside this zip you will find mysqldump.exe under bin folder.
3. Open the Mysql workbench. Go to Edit -> Preferences -> Administration.
4. Now, in Path to mysqldump Tool :, give the path of this downloaded mysqldump.exe

1. 下载与您的服务器版本相同的 mysql zip。（例如 mysql-5.7.25-winx64.zip）
2. 在此 zip 中，您将在 bin 文件夹下找到 mysqldump.exe。
3. 打开 Mysql 工作台。转到编辑 -> 首选项 -> 管理。
4. 现在，在 Path to mysqldump Tool : 中，给出这个下载的 mysqldump.exe 的路径

回答by killlinuxkill

I did take an archive for mysql version of need from here https://downloads.mysql.com/archives/community/

我确实从这里获取了 mysql 版本的存档https://downloads.mysql.com/archives/community/

And used from there mysqldump. It helped for me.

并从那里使用mysqldump。它对我有帮助。

回答by pinkp

As these answers are not totally clear for Mac users this is where I found my MySQLDump file:

由于这些答案对于 Mac 用户来说并不完全清楚，这是我找到 MySQLDump 文件的地方：

Applications > MAMP > Library > bin > mysqldump

应用程序 > MAMP > 库 > bin > mysqldump

A quick search of 'mysqldump' should locate this. I followed the above answers and go to:

快速搜索“mysqldump”应该可以找到它。我按照上述答案并转到：

Preferences > Administation > Path to mysqldump Tool:

首选项 > 管理 > mysqldump 工具的路径：

This was my path in there now: /Applications/MAMP/Library/bin/mysqldump

这是我现在的路径：/Applications/MAMP/Library/bin/mysqldump

回答by Dutch Glory

wb_admin_export.py (used by mysqldump) looks at PATHvariable to find mysqldump and get version number. make sure its mysqldump from mysql bundle, not mysql workbench...

wb_admin_export.py（由 mysqldump 使用）查看PATH变量以查找 mysqldump 并获取版本号。确保它的 mysqldump 来自 mysql 包，而不是 mysql 工作台...