title: mysql import dump file ubuntu 10.10
body: <p>am running mysql server on my machine using ubuntu, am trying to import dump file as indicated below, I get an error shown below as well:</p>
  
  <pre><code>create database mm;
  create user rami;
  set password for rami = password("112211");
  grant all privileges on prediction.* to rami identified by '112211';
  use prediction;
  -u rami -p mm &lt;/home/user/Downloads/SNPdbe_2012_03_05_sql;    
  </code></pre>
  
  <blockquote>
    <p>ERROR 1064 (42000): 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 '-u rami -p mm 
  </blockquote>