I thank you all who responded to solve my problem in using the source command to execute a mysql script saved on a notepad. Thank you, for your tips, I've solved the problem. When I was using the "\.create.sql" at the prompt I wasn't giving the full path where 'create.sql' is residing. Once I did, that thanks to you all, I saw my command line streaming with data and finally the result was in my database. Thanks.
Kebede