title: Mysqldump and gzip multiple tables with where clause not working in PhPMyAdmin
body: <p>I use AMPPS to run Apache and MySQL on a Mac OSX 10.9.2. I tried to mysqldump and gzip table1, table3 and table4 where <code>id</code> is greater than 500 through the PhPMyAdmin sql command line. However, after running the below query, MySQL said <code>#1064 - 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...</code>:</p>
  
  <pre class="lang-sh prettyprint-override"><code>mysqldump -u username -p password database1 table1 table3 table4 --where=`id`&gt;=500  | gzip &gt; /tmp/dumptables.sql.gz
  </code></pre>
  
  <p>Could you please take a look at the above query and let me know what is the problem? thanks</p>