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.

mysqldump Version Mismatch - WARNING message - screenshot:
mysqldump.exe is version 5.6.13, but the MySQL Server to be dumped has version 5.7.11.
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:

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.

Workbench Preferences' Administrator tab - screenshot

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

    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...

    More details >>

  • How to export MySQL database into a ‘.sql’ file on WAMP

    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...

    More details >>

  • My often used MySQL commands

    My often used MySQL commands

    Basic MySQL commands

    Basic commands for managing databases in MySQL on the command-line in local...

    More details >>

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.

Drupal Association member
Image of Edit