mysqldump error on simple python code

Question

I run the following simple python 2.7 code;

   dumpcmd = "mysqldump -u " + DB_USER + " -p" + DB_USER_PASSWORD + " " + db + " > " + TODAYBACKUPPATH + "/" + db + ".sql"
   os.system(dumpcmd)

The error I got is as follows;

mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an er
ror in your SQL syntax; check the manual that corresponds to your MySQL server v
ersion for the right syntax to use near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line
 1 (1064)

The strange thing is that my python code does not contain anything like SET OPTION SQL_QUOTE_SHOW_CREATE=1 as mentioned in the error. Can someone advise?

I got the python code here tecadmin.net/python-script-for-mysql-database-backup — guagay_wk
– guagay_wk, Commented Oct 13, 2014 at 10:18

javidcf · Accepted Answer · 2014-10-13 10:26:23Z

1

That seems to happen because you are using mysqldump 5.5 or prior with a MySQL 5.6 database. The SET OPTION syntax was removed (see discussion in this bug report), causing this tool to stop working.

You will need to update your version of mysqldump. More info about it in this other bug report.

edited Oct 13, 2014 at 10:26

answered Oct 13, 2014 at 10:17

javidcf

59.9k7 gold badges87 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

guagay_wk Over a year ago

Thanks. But the strange thing is that in my python code, there is no code like SQL_QUOTE_SHOW_CREATE=1

javidcf Over a year ago

@user3293156 Sorry, you are right, I misread the code. I have updated the answer.

Tim S · Accepted Answer · 2014-10-13 10:10:57Z

0

You might need a space between -p and DB_USER_PASSWORD.

dumpcmd = "mysqldump -u " + DB_USER + " -p " + DB_USER_PASSWORD + " " + db + " > " + TODAYBACKUPPATH + "/" + db + ".sql"

answered Oct 13, 2014 at 10:10

Tim S

5,1311 gold badge40 silver badges35 bronze badges

2 Comments

guagay_wk Over a year ago

Thanks for the answer. Unfortunately, it did not solve the problem.

Tim S Over a year ago

Perhaps try using from subprocess import call call(["mysqldump", "-u", DB_USER, "-p", DB_USER_PASSWORD, ...]) ?

guagay_wk · Accepted Answer · 2014-10-13 10:32:12Z

0

Thanks to the answer from javidcf, I found the answer to my question. The solution is to use a command-line mysqldump version that supports MySQL 5.6.

answered Oct 13, 2014 at 10:32

guagay_wk

28.3k64 gold badges202 silver badges311 bronze badges

Collectives™ on Stack Overflow

mysqldump error on simple python code

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related