mysqldump: Couldn’t execute ‘SET OPTION SQL_QUOTE_SHOW_CREATE=1’

A super detailed tutorial: springboot integrates mybatis plus>>>

Today, when preparing to export data with mysqldump, we encountered a problem:

mysqldump: Couldn’t execute ‘SET OPTION SQL_ QUOTE_ SHOW_ CREATE=1’: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_ QUOTE_ SHOW_ CREATE=1’ at line 1 (1064)

According to the prompt information, it is caused by the inconsistency between the MySQL version of the client and that of the target database, and the client MySQL does not support SQL_ QUOTE_ SHOW_ Create property

Client MySQL version:

mysql Ver 14.14 Distrib 5.5.30, for linux2.6 (x86_ 64) using readline 5.1

Target database mysql version:

mysql Ver 14.14 Distrib 5.7.10, for Linux (x86_ 64) using EditLine wrapper

Using a client above 5.6 can solve this problem

Similar Posts: