mysqldump returning unknown variable sql-mode error

Question

I'm getting this error when I run mysqldump like this:

$ mysqldump -u my_user -pXXX -h 127.0.0.1 --databases my_db > db_backup.sql
mysqldump: unknown variable 'sql-mode=STRICT_ALL_TABLES'

Does anyone know what could be going on?

I also get the same thing when I try to start the MySQL client.

Greg · Accepted Answer · 2012-08-13 18:31:22Z

4

Turns out I had "sql-mode=STRICT_ALL_TABLES" in the client settings section of my my.cnf file. I moved it to the server section and it seems all good.

answered Aug 13, 2012 at 18:31

Greg

47.5k91 gold badges239 silver badges298 bronze badges

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

Comments

Barmar · Accepted Answer · 2012-08-13 18:23:14Z

3

It's a bad line in your .my.conf file, or maybe one of your system .ini files.

answered Aug 13, 2012 at 18:23

Barmar

789k57 gold badges555 silver badges669 bronze badges

Collectives™ on Stack Overflow

mysqldump returning unknown variable sql-mode error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related