Mysql Load Sql From File

I'm running MySQL on Ubuntu 10.4 LTS and unfortunately I've been experiencing serious problems when it comes to importing a sql file. What I actually do: 1) I move to the directory containing the sql file which is called: bk.sql 2) Then I type: mysql -u root -p (and then I enter the root password and everything goes smoothly) 3) I use this command to do the import operation (assuming that password =123m Database name = Mydb sql file = bk.sql) mysql -u root -p 123m Mydb.

I'm trying to move a MySQL database from a Linux machine to one running Windows Vista. Using mysqldump, I've obtained a.sql file, which I have moved to the Windows machine. If I were moving to another Linux machine, one could do this sort of thing: mysql -u username -p databasename source C: Stuff dumpfile. Fm 2005 Completo Toronto. sql That gave: Failed to open file 'C: Stuff dumpfile.sql', error: 2. This same type of command should work in windows as well as Linux.