This is the mail archive of the cygwin mailing list for the Cygwin project.

Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Error using mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1'


I am trying to use cygwin to manage my local mysql server on my
Windows 7 machine. I was using CMD until I found out CMD does not
support sub commands. I am trying to run the following command:

mysqldump -u root -p -h DATABASE.NAME > /cygdrive/x/DATABASE.NAME.sql

where DATABASE.NAME is the name of the database I am trying to dump.
When I try running the command I get the following error:

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)

I have cygwin 1.7.20-1 and mysql server 5.6.12. I have the following
cygwin packages installed:

Cygwin Package Information
Package              Version              Status
_autorebase          000324-1             OK
_update-info-dir     01152-1              OK
alternatives         1.3.30c-10           OK
base-cygwin          3.3-1                OK
base-files           4.1-1                OK
bash                 4.1.10-4             OK
bzip2                1.0.6-2              OK
coreutils            8.15-1               OK
crypt                1.2-1                OK
cygutils             1.4.12-2             OK
cygwin               1.7.20-1             OK
dash                 0.5.7-1              OK
diffutils            3.2-1                OK
dos2unix             6.0.3-1              OK
editrights           1.01-2               OK
file                 5.11-1               OK
findutils            4.5.11-1             OK
gawk                 4.1.0-1              OK
gettext               OK
grep                 2.6.3-1              OK
groff                1.21-2               OK
gzip                 1.4-1                OK
ipc-utils            1.0-1                OK
less                 444-1                OK
libattr1             2.4.46-1             OK
libbz2_1             1.0.6-2              OK
libdb4.5              OK
libexpat1            2.1.0-2              OK
libgcc1              4.5.3-3              OK
libgdbm4             1.8.3-20             OK
libgmp3              4.3.2-1              OK
libiconv2            1.14-2               OK
libintl8              OK
libiodbc2            3.52.8-1             OK
liblzma5             5.0.2_20110517-1     OK
libmpfr4             3.0.1-1              OK
libmysqlclient-devel 5.5.28-1             OK
libmysqlclient18     5.5.28-1             OK
libmysqld-devel      5.5.28-1             OK
libmysqld0           5.5.28-1             OK
libncurses10         5.7-18               OK
libncursesw10        5.7-18               OK
libopenssl100        1.0.1e-2             OK
libpcre0             8.21-2               OK
libpopt0             1.6.4-4              OK
libreadline7         6.1.2-3              OK
libssp0              4.5.3-3              OK
libstdc++6           4.5.3-3              OK
libwrap-devel        7.6-21               OK
libwrap0             7.6-21               OK
libxml2              2.9.1-1              OK
login                1.10-10              OK
man                  1.6g-2               OK
mintty               1.1.3-1              OK
mysql                5.5.28-1             OK
mysql-test           5.5.28-1             OK
mysqld               5.5.28-1             OK
odbc-mysql           5.1.10-1             OK
openssl              1.0.1e-2             OK
openssl-devel        1.0.1e-2             OK
perl                 5.14.2-3             OK
perl-Clone           0.31-1               OK
perl-DBD-mysql       4.022-1              OK
perl-DBI             1.623-2              OK
perl_vendor          5.14.2-3             OK
rebase               4.4.0-1              OK
run                  1.2.0-1              OK
sed                  4.2.2-3              OK
tar                  1.26-1               OK
terminfo             5.7_20091114-14      OK
texinfo              4.13-4               OK
tzcode               2013c-1              OK
vim-minimal          7.3.1152-1           OK
which                2.20-2               OK
xz                   5.0.2_20110517-1     OK
zlib-devel           1.2.8-1              OK
zlib0                1.2.8-1              OK

When I searched the error it looks to me like the more recent versions
of mysql the sytax use SET SQL_QUOTE_SHOW_CREATE=1 rather than SET
OPTION SQL_QUOTE_SHOW_CREATE=1. I am not sure if this needs to be
updated in the cygwin mysql packages, but I am at a loss for how to
fix this issue.

Thank you so much,


Problem reports:
Unsubscribe info:

Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]