Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Where to download MySQLdump.ext newer version than mysqldump.exe ver 5.7.1.7

Tags:

mysql

mysql-workbench

Trying to dump simple database via MySQL Workbench by clicking... Server > Data Export >mydb>Start Export

Get Message: mysqldump Version Mismatch... the message shows these versions mysqldump.exe ver 5.7.1.7 MySQL Server ver 5.7.19

Read most of the post on topic here and see I need to point Workbench to newer version of mysqldump.exe via clicking Edit > Preferences > Administration

But when I point to the version found in C:\Program Files\MySQL\MySQL Workbench 6.3 CE then try the data export it still reports the mismatch.

So The Questions: 1 - Where do I download mysqldump.exe newer version? 2 - Or what is the solution?

I also found an app on the Win 10 machine that shows me all the MySQL stuff and allows me to Add or Update... and it reports that everything is up to date...

3 - But now I can't find out how to re-launch that tool... any ideas how to relaunch this app?

like image 635
Fran_3 Avatar asked Nov 03 '17 17:11

Fran_3

People also ask

What is Mysqldump EXE?

4 mysqldump — A Database Backup Program. The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server.

How do I change MySQL version in MySQL workbench?

2. Open "Edit" > "Preferences" > "Modeling" > "MySQL" and look for "Default target MySQL Version" ---- Or see https://github.com/mysql/mysql-workbench/blob/8.0.11/plugins/db.mysql/backend/db_plugin_be... and confirm "5.6. 30" is hard-coded. Suggested fix: Change "5.6.

3 Answers

I use MySQL Community Edition and I solved this problem today.

  1. goto https://dev.mysql.com/downloads/mysql/
  2. download the ZIP archive of your desired version
  3. Open the ZIP archive and go to "bin" folder
  4. extract MYSQLDUMP.EXE where you want
  5. Close the Zip Archive and open MySQl Workbench
  6. In MySql Workbench goto to Edit > Preferences > Administration
  7. Select the file that you just extracted in "Path to mysqldumptool"
  8. Press OK and it's done!

31/01/2019 update: I need a Workbench or mysqldump.exe that works with a MySql server 5.7.18 CE. I can't find anything. Who can help me?

like image 124
Massimo Griffani Avatar answered Oct 17 '22 14:10

Massimo Griffani

To download the mysqldump.exe version needed by MySQL Workbench to execute a dump, you have to download the MySQL Community Server from:

  • if you need the latest GA version: https://dev.mysql.com/downloads/mysql/
  • if you need previous GA versions: https://dev.mysql.com/downloads/mysql/ then click on "Looking for previous GA versions?"
  • if you need an oldest archived version: https://downloads.mysql.com/archives/community/

After you have the archive, you can find mysqldump.exe inside "/bin" folder.

This is a standalone software so you can copy it where you want, then delete the rest of the archive.

like image 36
Riccardo Avatar answered Oct 17 '22 14:10

Riccardo

Make sure you get 5.7 not 8.0 version of the zip file and extract all of the zip.

like image 1
Thomas A. Johnson Avatar answered Oct 17 '22 14:10

Thomas A. Johnson
Sign in to Comment

Related questions

selecting records in mysql db from 1, 7, and 30 days ago with datetime and php
How to use multiple databases dynamically for one model in CakePHP
JPA- Joining two tables in non-entity class
SQLAlchemy JSON as blob/text
PHP Error: Maximum function nesting level of '100' reached, aborting [duplicate]
JPA @Size annotation for BigDecimal
Problem installing mysql gem on Snow Leopard: uninitialized constant MysqlCompat::MysqlRes
Confusing PDO-only problem : Can't connect through socket/Access denied/Can't connect to server (shared host)
Get Last Monday - Sunday's dates: Is there a better way?
Merge and Sort two Eloquent Collections?
ld: library not found for -lzstd while bundle install for mysql2 gem Ruby on macOS Big Sur 11.4
Importing data from geonames.org database into MySQL DB
How to connect MySQL database using Python+SQLAlchemy remotely?
How to search a column name from a MySQL database? [duplicate]
SELECT last id, without INSERT
What is the limit of auto_increment (integer) in mysql
Mysql Bigint VS Varchar
sql stored procedure vs code, which one is better? [closed]
MySQL Import Database Error because of Extended Inserts
Trying to perform MINUS operation in MySQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!