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;"

book

Article ID: 40139

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Problem:

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)

 

Environment:

NFA 9.3.x or later.

 

Cause:

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.

 

Resolution:

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.

 

 

Environment

Release:
Component: NQRACO