MySQL 在哪里下载 MySQLdump.ext 比 mysqldump.exe 版本 5.7.1.7 更新的版本

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/47101540/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 22:50:49  来源:igfitidea点击:

Where to download MySQLdump.ext newer version than mysqldump.exe ver 5.7.1.7

mysqlmysql-workbench

提问by Fran_3

Trying to dump simple database via MySQL Workbench by clicking... Server > Data Export >mydb>Start Export

尝试通过 MySQL Workbench 转储简单的数据库,方法是单击... Server > Data Export >mydb>Start Export

Get Message: mysqldump Version Mismatch... the message shows these versions mysqldump.exe ver 5.7.1.7 MySQL Server ver 5.7.19

获取消息:mysqldump 版本不匹配...消息显示这些版本 mysqldump.exe ver 5.7.1.7 MySQL Server ver 5.7.19

Read most of the post on topic here and see I need to point Workbench to newer version of mysqldump.exe via clicking Edit > Preferences > Administration

在此处阅读有关主题的大部分帖子,并查看我需要通过单击“编辑”>“首选项”>“管理”将 Workbench 指向较新版本的 mysqldump.exe

But when I point to the version found in C:\Program Files\MySQL\MySQL Workbench 6.3 CE then try the data export it still reports the mismatch.

但是当我指向在 C:\Program Files\MySQL\MySQL Workbench 6.3 CE 中找到的版本然后尝试导出数据时,它仍然报告不匹配。

So The Questions: 1 - Where do I download mysqldump.exe newer version? 2 - Or what is the solution?

所以问题: 1 - 我在哪里下载 mysqldump.exe 较新版本?2 - 或者解决方案是什么?

I also found an app on the Win 10 machine that shows me all the MySQL stuff and allows me to Add or Update... and it reports that everything is up to date...

我还在 Win 10 机器上找到了一个应用程序,它向我展示了所有 MySQL 内容,并允许我添加或更新......并且它报告一切都是最新的......

3 - But now I can't find out how to re-launch that tool... any ideas how to relaunch this app?

3 - 但现在我不知道如何重新启动该工具...任何想法如何重新启动这个应用程序?

回答by Massimo Griffani

I use MySQL Community Edition and I solved this problem today.

我使用 MySQL 社区版,今天解决了这个问题。

  1. goto https://dev.mysql.com/downloads/mysql/
  2. download the ZIP archive of your desired version
  3. Open the ZIP archive and go to "bin" folder
  4. extract MYSQLDUMP.EXE where you want
  5. Close the Zip Archive and open MySQl Workbench
  6. In MySql Workbench goto to Edit > Preferences > Administration
  7. Select the file that you just extracted in "Path to mysqldumptool"
  8. Press OK and it's done!
  1. 转到https://dev.mysql.com/downloads/mysql/
  2. 下载所需版本的 ZIP 存档
  3. 打开 ZIP 存档并转到“bin”文件夹
  4. 将 MYSQLDUMP.EXE 提取到您想要的位置
  5. 关闭 Zip 存档并打开 MySQl Workbench
  6. 在 MySql Workbench 中转到编辑 > 首选项 > 管理
  7. 在“mysqldumptool的路径”中选择刚才解压出来的文件
  8. 按确定就完成了!

31/01/2019 update: I need a Workbench or mysqldump.exe that works with a MySql server 5.7.18 CE. I can't find anything. Who can help me?

31/01/2019 更新:我需要一个 Workbench 或 mysqldump.exe,它可以与 MySql 服务器 5.7.18 CE 配合使用。我找不到任何东西。谁能帮我?

回答by Riccardo

To download the mysqldump.exeversion needed by MySQL Workbenchto execute a dump, you have to download the MySQL Community Serverfrom:

要下载MySQL Workbench执行转储所需的mysqldump.exe版本,您必须从以下位置下载MySQL 社区服务器

After you have the archive, you can find mysqldump.exeinside "/bin" folder.

获得存档后,您可以在“/bin”文件夹中找到mysqldump.exe

This is a standalone software so you can copy it where you want, then delete the rest of the archive.

这是一个独立的软件,因此您可以将其复制到您想要的位置,然后删除存档的其余部分。

回答by Thomas A. Johnson

Make sure you get 5.7 not 8.0 version of the zip file and extract all of the zip.

确保您获得 5.7 而非 8.0 版本的 zip 文件并解压缩所有 zip。

回答by Lloyd Tatenda Chimanga

Dont worry about different versions. Go to edit-Preference-administration- (careful here. go to mysql dump.exe that is found in xampp folder not mysql folder.) example of path should be like C:\xampp\mysql\bin\mysqldump.exe. copy the path and paste in .path to mysqldump Tool.

不要担心不同的版本。转到编辑-首选项-管理-(这里要小心。转到在 xampp 文件夹中找到的 mysql dump.exe,而不是 mysql 文件夹。)路径示例应类似于 C:\xampp\mysql\bin\mysqldump.exe。复制路径并将 .path 粘贴到 mysqldump 工具。

回答by Emma

After installing mysql 5.7 it comes with all the dumptools and stuff so visit C:\Program Files\MySQL\MySQL Server 5.7\bin\ from Edit > Preferences > Administration > path to dump tool and select your sql dump tool

安装 mysql 5.7 后,它带有所有转储工具和东西,因此请从编辑 > 首选项 > 管理 > 转储工具路径访问 C:\Program Files\MySQL\MySQL Server 5.7\bin\ 并选择您的 sql 转储工具

note: same apply for any version of sql just navigate and get the dump tool for that version.

注意:同样适用于任何版本的 sql 只需导航并获取该版本的转储工具。