Why does mysqldump fail with an error. How to overcome?

W

wolandino2014-09-01 12:37:02

MySQL

wolandino, 2014-09-01 12:37:02

Good afternoon,
Initial data:
CentOS release 6.5 (Final) x64;
mysqldump Ver 10.13 Distrib 5.5.25a, for Linux (x86_64)
MySQL Server version: 5.5.5-10.1.0-MariaDB MariaDB Server
Trying to dump an arbitrary table (using the mysqldump utility) results in:
mysqldump: Couldn't execute 'SET OPTION' SQL_QUOTE_SHOW_CREATE=1': Unknown system variable 'OPTION' (1193)
Is there any way to overcome this?
Solutions found in Google did not give an answer.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

V

Vladimir, 2014-09-01
@rostel

install fresh mysql-client

I

Igor, 2014-09-01
@merryjane

Is this option missing in /etc/my.cnf ( SQL_QUOTE_SHOW_CREATE=1 )?
If it is registered, comment it out for the duration of the dump.