How to make sure that the mysqldump.exe version of MySQL Workbench is equal to or newer than that of the target server.
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 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.
MySQL Workbench 6.0 (Version 22.214.171.12421)
WampServer 3 (64 BITS & PHP 5.6 & PHP 7)
Operating system: Windows 10
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...