X-Recipient: archive-cygwin AT delorie DOT com DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id :list-unsubscribe:list-subscribe:list-archive:list-post :list-help:sender:mime-version:date:message-id:subject:from:to :content-type; q=dns; s=default; b=Hm/KtgHiEEelKeWpY7+dVOCTgTJoK UrSKn7OnMyJ3xPyK+GPqhU/1SiwOeMExs9e3VWwZYjamjXfaApAdVTCYeymdjkzq ctB+oS734YHqyJP+kYP64i1FPXLE5f9/K5az5ZTOvqOaei1J76ekj6M9LlomICWq XxIHUnU+ljog9A= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id :list-unsubscribe:list-subscribe:list-archive:list-post :list-help:sender:mime-version:date:message-id:subject:from:to :content-type; s=default; bh=m2NA3ryutxY1UEv7zRBFKh7eIVY=; b=jsu /nf2Yd/eRvPUF67Fl5YwrDU3rw8peqVGBk1CItnHcwNvJDBC+k1dyCR18DDmdToV g9obItzMYvcq9R0Z1vvdknX6M3QmAalai4q9FTSXMoFh1EnIqU/sncleqe+BCud3 R5eik11469XXMcGsQQxEVNLaZSzIpXD1npdBHgMQ= Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com X-Spam-SWARE-Status: No, score=0.3 required=5.0 tests=AWL,BAYES_00,FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,RCVD_IN_HOSTKARMA_YE,SPF_PASS,TW_BG,TW_BL,TW_BX,TW_IB,TW_QL autolearn=ham version=3.3.1 MIME-Version: 1.0 X-Received: by 10.49.95.97 with SMTP id dj1mr38061616qeb.46.1372775886260; Tue, 02 Jul 2013 07:38:06 -0700 (PDT) Date: Tue, 2 Jul 2013 10:38:06 -0400 Message-ID: Subject: Error using mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1' From: Dayne Filer To: cygwin AT cygwin DOT com Content-Type: text/plain; charset=ISO-8859-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