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:
- [Solved] Backup mysql8.0 with the mysqldump of mysql5.7 Error
- mysqldump unknown table ‘column_statistics’
- How to Sovle mysqldump backup Error on the MySQL command line
- Mysqldump common error reports and Solutions
- [Warning] Using a password on the command line interface can be insecure. (Solved)
- [Solved] Deploying Tomcat connection in Linux Navicat reports error 2059 – authentication plugin ‘caching_sha2_Password ‘cannot be loaded: + Xi input 9 g
- IDEA Connect MYSQL Error: You have an error in your SQL syntax : ‘OPTION SQL_SELECT_LIMIT=1000’ （or…
- Solution to empty backup file generated by mysqldump scheduled task
- How to Solve MYSQL Error: mysqldump: Error 2013
- [Solved] PostgreSQL configure: error: readline library not found