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. Whats next?
If I were moving to another Linux machine, one could do this sort of thing:
mysql -u username -p databasename < dumpfile.sql
Does anyone know of an analogous invocation that works from the Windows command line? Or are there tools to accomplish this?
When I try this type of command from the Windows command line, I get:
'mysql' is not recognized as an internal or external command
I've also tried:
mysql> source C:\Stuff\dumpfile.sql
That gave:
Failed to open file 'C:\Stuff\dumpfile.sql', error: 2