I am using a webserver that is administered by someone else. The version of mysqldump on this server is from 2011:$ mysqldump --helpmysqldump  Ver 10.13 Distrib 5.1.63, for debian-linux-gnu (x86_64)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.As a result, when I try to do a database dump, I get this output: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)According to this link I need to upgrade mysqldump.I asked my sysadmin to do it, and got generic non-helpful responses. I doubt I will be able to convince them to do the upgrade. Moving to a new server is not an option at the moment. Is there some way I can download and compile a local version in my home directory (without having to compile a gazillion dependencies)? If so, would you mind pointing me in the right direction?Thanks!
Download / Compile local version of mysqldump
compiling;mysql
Your link also contains the quickest solution:Andre Couture  3 years agoHi, I had the same issue trying to mysqldump a 5.6 database in order  to downgrade. I took a slightly different approach as I did not had  the luxury to install mysql-client5.6I simply did a copy of /usr/bin/mysqldump, vi -b mysqldump look for  SET OPTION ( use the '/' command) replace the first character by # in  order to read #ET OPTION (use the 'r' command) save and ran my dump  ( ESC :x )Now you have a version of mysqldump that can connect and dump data  from mysql5.6Worked like a charm for me