title: how to read an sql file into sqlite command in Mac terminal window
body: <p>I am trying to point to a file I have under a path. 
  my <code>test2.sql</code> look like this: </p>
  
  <pre><code>create table setting (id integer primary key, status text)
  insert into setting values (1, 'new')
  </code></pre>
  
  <p>When I type this command:</p>
  
  <pre><code>sqlite&gt; .read users/name/test2.sql
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>Error: cannot open "test2.sql"
  </code></pre>
  
  <p>or behaves as if it has executed without error but no records get added to the table.</p>
  
  <p>I do </p>
  
  <pre><code>sqlite&gt; select * from setting;
  </code></pre>
  
  <p>and that goes back to:</p>
  
  <pre><code>sqlite&gt; 
  </code></pre>
  
  <p>Are there any gotchas to using the <code>.read</code> command?</p>