使用mysql导出数据库 [英] EXPORT database with mysql

问题描述

我本周开始研究MySQL，所以我安装了最新版本的MySQL CLient for Windows。我到了试图导出数据库的地步。我想导出我的数据库并且它一直警告我：



mysqldump Version Mismatch



mysqldump .exe是版本5.7.12，但要转储的MySQL服务器版本为5.7.17。

因为mysqldump的版本比服务器旧，所以某些功能可能无法正常备份。 br />
建议您将本地MySQL客户端程序（包括mysqldump）升级到等于或高于目标服务器的版本。

转储工具的路径必须在首选项中设置 - >管理员 - > mysqldump工具的路径：



我尝试过：



我从这个和其他论坛搜索了不同的解决方案。



我将我的mysql工具文件夹的路径设置为：C：\Program Files \ MySQL \ MySQL Server 5.7 \bin\mysqldump.exe。并重新启动了我的WorkBench。但这对我也没有帮助。



如果有一些可用的更新但是看起来我有最新版本，我用安装程序检查过。所以没有。



任何建议人员？

Hi, I started studing MySQL in this week so I installed newest version of MySQL CLient for Windows . I'm getting to the point where I try to export database. I want to export my database and it' keeps warning me:

"mysqldump Version Mismatch

mysqldump.exe is version 5.7.12, but the MySQL Server to be dumped has version 5.7.17.
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 of the dump tool must then be set in Preferences -> Administrator -> Path to mysqldump tool:"

What I have tried:

I searched different solution from this and other forums.

I set my path to mysql tool folder to: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe. And restarted my WorkBench. But that didn't help me either.

I checked with installer if there is some updates available but it looks like I have newest version. So there isn't.

Any sugsestions folks?

推荐答案

看看这个：MySQL ::问题创建导出（备份） [ ^ ]

这篇关于使用mysql导出数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！