How to restore mysql dump file? We have created a dump file (.sql) using the command mysqldump in mysql5.5.
Now we want to restore the same. We are using the command :-

-u[username] -p[pwd] [dbname] &lt; [.sql file]

But we are not able to restore.
We are using Win7 SP1 32 bit OS.
Looks like you left part of your command off.  To be clear, you'll need to use the mysql client for the import.  But, in general that should work.  Another option is to just connect to the client (same command as before, but with out the the 

Once in you can run

mysql&gt; source /path/to/outfile.sql