title: Export mysql Error 1064 <42000>: You have an error in your sql syntax
body: <p>I have seen many replies to this question, but none of the solutions worked for me, so i am repeating the same question.
  I am using mysql 5.5.30 on windows xp.
  I am able to open mysql command line by giving this command:<br>
      <code>d:\mysql\usr\local\mysql\bin&gt;mysql –uroot –proot</code></p>
  
  <p>But when i use the same username and password to export a database by giving this command:<br>
       <code>mysql&gt;mysqldump -uroot -proot svga3 &gt; dbsqlfile.sql</code><br>
  I GET THIS ERR:</p>
  
  <pre><code>Error 1064 &lt;42000&gt;: 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 'mysqldump -uroot -proot svga3 &gt; dbsqlfile.sql
  </code></pre>
  
  <p>AFTER seeing many on responses and tried all combinations of the same line, it does't work, need help!</p>
  
  <p>Other option tried:</p>
  
  <pre><code> mysqldump -u root -p root svga3 &gt; dbsqlfile.sql
   mysqldump -uroot -p svga3 &gt; dbsqlfile.sql
   mysqldump -u root -p=root svga3 &gt; dbsqlfile.sql
   mysqldump -u -p svga3 &gt; dbsqlfile.sql
  </code></pre>