i am new to mysql
i have a file full of sql statements

insert into mysql1.table1 values(4343);

now i want to run these statements and create my mysql table with data in it.
i was told to use a SOURCE command but iam having problems

from the mysql prompt i tried
mysql> source test.sql ( this is the file that has all the sql statements)
and i got "file could not be located" error: 2

my questions:
how can i syntactically specify the location of my file ?
will the SOURCE command server my purporse?