MySQL Workbench] mysqldump Version Mismatch

mysqldump Version Mismatch

mysqldump.exe is version 8.0.20, but the MySQL Server to be dumped has version 5.6.48. Because the version of mysqldump is not the same as the server, some features may not be backed up properly. It is recommended you upgrade or downgrade 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:

이 때 Continue Anyway를 선택해 강제로 Data Export를 진행하니 DB가 schema가 아니라 column 단위로 산산조각 났다...

---

방법 1. Workbench 버전 맞추기

 Workbench 버전을 Server 버전에 맞추자

Wordkbench에 접속해 Edit → Preferences...

MySQL → Model → Default Target MySQL Version 확인

버전을 8.0에서 5.6으로 바꾸고

 Administration → Path to mysqldump Tool 경로를 C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe(내 기준)로 바꿈