Categories
export mysql mysql-workbench php

mysqlworkbench giving version error on exporting database

When I try to export my database through MySQL Workbench remotely from localserver,

I am getting some below version error:

mysqldump Version Mismatch [Content] mysqldump.exe is version 5.5.16, but the MySQL Server to be dumped has version 5.6.10-log. 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

I am trying to find a solution – I searched for solution on google but couldn’t find a good answer to solve the issue.

Does anyone know, how to fix this issue in MySQL Workbench?

Go to: Edit -> Preferences -> Administrator -> Path to Mysqldumptool:

Look for file mysqldump.exe in your MySQL Server installation folder (it could be: mysql/bin/).
Then click it, and OK. After that try to do the backup.