Mysqldump failing on NFA servers with error: "mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax;"
Updated On:14-02-2018 07:45
CA Network Flow Analysis (NetQos / NFA)
After ugprading to NFA 9.3.x or later, mysqldump may fail with the error below:
D:\>mysqldump reporter > reporter.sql
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)
NFA 9.3.x or later.
NFA 9.3.x introduced an upgrade to MySql 5.6. If the old Mysql 5.1 bin directory is still in the system PATH variable, it can cause mysqldump to try and use the wrong version of mysql.
1. Remove the \Mysql51\bin directory from the System PATH variable and make sure that the new \Mysql\bin directory is in the PATH.
2. Open a new command prompt and attempt the mysqldump again.