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

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

EXPORT database with mysql

1 solution

Solution 1

Add your solution here

Preview 0

EXPORT database with mysql

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us