This is the mail archive of the
cygwin
mailing list for the Cygwin project.
Error using mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1'
- From: Dayne Filer <dayne dot filer at gmail dot com>
- To: cygwin at cygwin dot com
- Date: Tue, 2 Jul 2013 10:38:06 -0400
- Subject: Error using mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1'
Hello:
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 127.0.0.1 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 0.18.1.1-2 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 4.5.20.2-3 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 0.18.1.1-2 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,
Dayne
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple