EXPORT database with mysql

Question

0.00/5 (No votes)

See more:

Hi, I started studing MySQL in this week so I installed newest version of MySQL CLient for Windows . I'm getting to the point where I try to export database. I want to export my database and it' keeps warning me:

"mysqldump Version Mismatch

mysqldump.exe is version 5.7.12, but the MySQL Server to be dumped has version 5.7.17.
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 of the dump tool must then be set in Preferences -> Administrator -> Path to mysqldump tool:"

What I have tried:

I searched different solution from this and other forums.

I set my path to mysql tool folder to: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe. And restarted my WorkBench. But that didn't help me either.

I checked with installer if there is some updates available but it looks like I have newest version. So there isn't.

Any sugsestions folks?

Posted 15-Feb-17 4:23am

Member 13000170

Updated 15-Feb-17 4:38am

Afzaal Ahmad Zeeshan

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2017-02-15T04:38:00

Solution 1

Check this out: MySQL :: Issue creating export (backups)[^]

Posted 15-Feb-17 4:38am

Peter Leow

Comments

Member 13000170 15-Feb-17 11:04am

Thank you a lot mate ! This helped me fix my problem ! You're the man !

Member 13000170 15-Feb-17 11:25am

Now it OK with export. It woun't dipay this Warning message. But when I try to import my exported database it gives me error.

18:22:06 Restoring C:\Users\Henso\Documents\dumps\Monkey.sql
Running: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe" --defaults-file="c:\users\henso\appdata\local\temp\tmpntdmtd.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "C:\\Users\\Henso\\Documents\\dumps\\Monkey.sql"
mysqldump: Got error: 1049: Unknown database '<' when selecting the database

Operation failed with exitcode 2
18:22:06 Import of C:\Users\Manu\Documents\dumps\Monkey.sql has finished with 1 errors

Peter Leow 15-Feb-17 11:36am

Check your export operation, as the error message said it
Unknown database '<' when selecting the database