Behavior:
When attempting to backup the MySQL database, workbench displays the below error:
ERROR: "mysql dump Version Mismatch. mysql dump.exe is version 5.X.XX but the MySQL Server to be dumped has version 5.X.XX-log. Because the version of mysql dump is older than the server, some features may not be backed up properly. It is recommended you upgrade your local MySQL client programs, including mysql dump to a version equal to or newer than that of the target server."
Solution:
The issue is caused by the mysqldump version selected by MySQL Workbench.
You can change the mysqldump used by Workbench:
When attempting to backup the MySQL database, workbench displays the below error:
ERROR: "mysql dump Version Mismatch. mysql dump.exe is version 5.X.XX but the MySQL Server to be dumped has version 5.X.XX-log. Because the version of mysql dump is older than the server, some features may not be backed up properly. It is recommended you upgrade your local MySQL client programs, including mysql dump to a version equal to or newer than that of the target server."
Solution:
The issue is caused by the mysqldump version selected by MySQL Workbench.
You can change the mysqldump used by Workbench:
- Open MySQL Workbench.
- Navigate to the Preferences submenu: Edit -> Preferences.
- In the Preferences menu, find the Administration tab.
- From the Administration tab, you will see fields for setting the paths to various MySQL utilities, including mysqldump.
- Enter the full path to your desired mysqldump executable. For example, if your mysqldump is located at C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe, you will enter that path.
- Save the changes by clicking OK or Apply.
- Close and reopen MySQL Workbench to ensure the changes took effect.
This KBA is applicable to on-premise organizations ONLY.