mysqlworkbench giving version error on exporting database

php mysql export mysql-workbench
Sizzling Code picture Sizzling Code · Mar 26, 2013 · Viewed 86.6k times · Source

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?

Answer

Gustavo picture Gustavo · Mar 28, 2013

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.

Related questions

Export MySQL data to Excel in PHP

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text goes to one cell, I would like to have each row value in separate Excel cell. Here is my code: $…

Read More
Easy way to export a SQL table without access to the server or phpMyADMIN

I need a way to easily export and then import data in a MySQL table from a remote server to my home server. I don't have direct access to the server, and no utilities such as phpMyAdmin are installed. I …

Read More
How to export database with Adminer?

It's the first time i use ADMINER. I want to export the database and i'm not sure to set correctly the parameters. The database is in production and i don't want to make any mistakes. See screenshot : What are the …

Read More