This question is an exact duplicate of:
- How to restore mysql dump file? [closed] 2 answers
I'm trying to restore a mysql5.5 dump file using mysql command prompt using the command given below:
mysql> -u <username> -p <password> <dbname> < <dumpfile>
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< "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.