I am using a webserver that is administered by someone else. The version of
mysqldump on this server is from 2011:
$ mysqldump --help
mysqldump 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
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?