title: MySQL mysqldump command error(bug in mysql 5.5)
body: <p>I am working on exporting a table from my server DB which is about few thousand rows and the PHPMyadmin is unable to handle it.So I switched to the <strong>command line option</strong><br/>
  But I am running into this error after executing the <code>mysqldump</code> command.The error is</p>
  
  <p><code>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)</code><br/>
  After doing some search on the same I found this as a <a href="http://bugs.mysql.com/bug.php?id=67507" rel="nofollow">bug</a> in the mysql version 5.5 not supporting the <code>SET OPTION</code> command.<br/><br/>
  I am running a EC2 instance with centos on it.My mysql version is <code>5.5.31</code>(from my phpinfo).
  <br/><strong>I would like to know if there is a fix for this as it wont be possible to upgrade the entire database for this error</strong>.<br/>
  Or if there is any other alternative to do a export or dump,please suggest. </p>