how to read an sql file into sqlite command in Mac terminal window

I am trying to point to a file I have under a path. my test2.sql look like this: create table setting (id integer primary key, status text) insert into setting values (1, 'new')

When I type this command: sqlite> .read users/name/test2.sql

I get this error: Error: cannot open "test2.sql" or behaves it has executed without error but no records get added to the table. I do sqlite> select * from question; and goes back to: sqlite>

Are there any gotachs to using the .read command!?