title: Getting mysqldump: [ERROR] unknown variable 'column-statistics=0' when exporting database though shell in MAMP
body: <p>I am trying to export a database in mysql from Mac terminal using</p>
  
  <pre><code> /Applications/MAMP/Library/bin/mysqldump -u root -p databasename tablename &gt; /Users/mir/Documents/data.sql
  </code></pre>
  
  <p>It's giving me an error  <strong>mysqldump: [ERROR] unknown variable 'column-statistics=0'</strong></p>
  
  <p>I have tried many solutions like 
  (i) adding "--column-statistics=0" in the query itself and
  (ii) adding </p>
  
  <pre><code>[mysqldump]
  column-statistics=0
  </code></pre>
  
  <p>in my.cnf at /Applications/MAMP/conf/my.cnf. </p>
  
  <p>Nothing solve the issue.
  Looking for help.</p>