Trick to running existing .sql file in mysql command prompt?

[Marc M]

I've seen "examples" of this in my book on MySQL, but it just shows the file on the prompt.
It says that I can run an existing sql file - for creating a table - right from the prompt.
However, it doesn't really explain how to do this in detail. I've tried :
-h host - u user -D database -p < myfile.sql
but it gives an error. How do I point it to the right file on my system?
Call me dense, but I can't find any solid info on this.

Any takers?
-m

------------------------
Inner space - what a trip.