Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to get most recent mySQLdump tool

Tags:

mysql

dump

Perhaps not really a suitable SO question but I'll give it a try.

When I try to dump my DB from the remote server, my MySQL workbench for MacOS tells me:

Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump is version 5.7.12, but the MySQL Server to be dumped has version 5.7.15. 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 have version 6.3 installed, and the built-in "check for updates" only tells me I already have the latest version.

Does anyone know where I can go to download this more recent dump tool? I looked around on the MySQL.com but couldn't find it.

like image 507
Matt Welander Avatar asked Jan 30 '17 12:01

Matt Welander


People also ask

How do I find Mysqldump version?

To see a list of the options your version of mysqldump supports, issue the command mysqldump --help .

What is Mysqldump command?

It dumps one or more MySQL databases for backup or transfer to another SQL server. The mysqldump command can also generate output in CSV, other delimited text, or XML format.


1 Answers

There's a simple way to solve your problem.

Just go on google type: mysqldump 5.7.20 (this number is the version are you looking for, in my case is 5.7.20) choose the link site from https://dev.mysql.com/downloads/mysql/ on that page scroll down until you see a list of avaible downloads, choose your operating system (in my case is Windows) then... download the zip that has the version you are looking for. unzip that folder... go to bin inside it... from there copy mysqldump and paste it into your MySQLWorkbench folder... (replacing the one is in there) restart your MySQLWorkbench... and that is all.

like image 143
Cristian Babarusi Avatar answered Oct 20 '22 15:10

Cristian Babarusi