title: Enable binary mode while restoring a Database from an SQL dump
body: <p>I am  extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a dumpfile in MySQL, but I get the following error:</p>
  
  <pre><code>$ &gt;mysql -u root -p -h localhost -D database -o &lt; dump.sql
  ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: 'SQLite format 3'.
  </code></pre>
  
  <p>I have tried putting <code>--binary-mode</code> in the ini file but it still gives the same error. What should I do? Please help. </p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>As suggested by Nick in his comment I tried <code>$ &gt; mysql -u root -p -h localhost -D database --binary-mode -o &lt; dump.sql</code> but it gave me the following <code>ERROR at line 1: Unknown command '\☻'.</code> 
  It is a 500 Mb dump file, and when I view its contents using gVIM, all I can see is expressions and data which is not comprehensible. </p>