Author: Edit Olah
‘mysqldump Version Mismatch’ warning from MySQL Workbench
Changing the path to mysqldump program file
How to make sure that the mysqldump.exe version of MySQL Workbench is equal to or newer than that of the target server.
The problem
Sometimes when trying to export a database through MySQL Workbench from a local server, you get a ‘mysql Version Mismatch’ warning.
As it says, it is just a warning, so when you click ‘Continue Anyway’ the database dump is created.
The solution
The warning is quite informative in this case. All you need to do is to update/specify Workbench’s path to the dump tool.
1. Go to ‘Edit’ > ‘Preferences’ in the top navigation and click on the ‘Administrator’ tab.
2. Find ‘Path to mysqldump Tool:’ and browse to the ‘mysqldump.exe’ program in your server.
Currently, I am using WampServer 3, so the path is: ‘C:\wamp64\bin\mysql\mysql5.7.11\bin\mysqldump.exe’.
3. Hit ‘OK’.
4. Try to export the database into a dump file again. It should no longer show the warning.
System details:
MySQL Workbench 6.0 (Version 6.0.9.11421)
WampServer 3 (64 BITS & PHP 5.6 & PHP 7)
Operating system: Windows 10
Resources:
stackoverflow: mysqlworkbench giving version error on exporting database
MySQL 5.7 Reference Manual: 5.5.4 mysqldump — A Database Backup Program -
Related blog posts
-
Setting up multiple projects in WAMP 3 with aliases
Local development environment
When you have to set up a development environment quickly on a Windows...
-
How to export MySQL database into a ‘.sql’ file on WAMP
MySQL dump in Windows command prompt
If you are used to Linux/Unix based environments using the command line...
-
My often used MySQL commands
Basic MySQL commands
Basic commands for managing databases in MySQL on the command-line in local...
Contact Edit
Get in touch
If you are interested in hiring me, please drop me an email. I would be happy to send you my up-to-date resume.
Edit Olah, Web developer
