Unable to restore dump file in mysql5.5 I'm trying to restore a mysql5.5 dump file using mysql command prompt using the command given below:

mysql&gt; -u &lt;username&gt; -p &lt;password&gt; &lt;dbname&gt; &lt; &lt;dumpfile&gt;


But it is giving the below error:


  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 ro
  ot -p password mydb&lt; "D:\mysql_dump\backup_2013_01_mydb.sql"' at line 1


Please help. I've tried it on both WinXP and Win7.
Also please guide how to do the same using Mysql Workbench.
Please check the link below for the answer.

https://dba.stackexchange.com/a/36043/20734

Thank You