syntax errors from mysqldump

said76 · 05-18-2013, 07:02 AM

Hi,

I am encountering the following errors when running my automysqlbackup on Ubuntu Server 12.04.02 LTS

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)
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)
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 am wondering if anyone might have come across these errors before and how to get around it.

Thank you in advance

Habitual · 05-18-2013, 07:58 AM

Test manually using terminal >

Code:

mysqldump -uroot -p test > ./test.sql

This will dump the test db which I think is installed default these days. This is only a test. Please don't omit it.

Did you read the README?
It's discusses running the script and how.

http://bugs.mysql.com/bug.php?id=66765

bloodstreetboy · 05-25-2013, 02:52 AM

Quote:

Originally Posted by Habitual

Test manually using terminal >

Code:

mysqldump -uroot -p test > ./test.sql

In this example -p test is specified, test is a name of database, it is not the password. See the exported file is test.sql, it takes backup of database test into test.sql.
In this case password is empty because by default there is no password for root (in lampp) and if you leave password field empty while mysql installation.