title: Create sqlite3 database from .sql file
body: <p>The goal is to make a database out of a .sql file.</p>
  
  <p>I'm trying to set up a local environment to test and modify this red5 implementation</p>
  
  <p>Step 1 is </p>
  
  <p><code>Create a database using the SQL command in database/database.sql</code></p>
  
  <p>I'm on Windows, so I'm on Cygwin, with sqlite3 and a few other things installed, so I figured I'd make a database out of that.</p>
  
  <p>When I try to load the file (That I moved) in an effort to make a database out of it, I get this.</p>
  
  <pre><code>$ sqlite3
  SQLite version 3.7.16.2 2013-04-12 11:52:43
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite&gt; .load database.sql
  Error: %1 is not a valid Win32 application.
  </code></pre>
  
  <p>I've googled around and this seems to be a problem with the file path to the application.</p>
  
  <p>The actual path is <code>D:\cygwin\home\Houseman\database.sql</code></p>
  
  <p>I'm in my home directory when I run <code>sqlite3</code>, so it should be right there, and accessible.</p>
  
  <p>How can I do this?</p>
  
  <p>Also, if there's a better way about setting up a temporary database so that I can test this application that is, apparently, dependent upon databases, that'd be helpful too.</p>
  
  <p>Thanks</p>
  
  <hr>
  
  <p>My database.sql file is </p>
  
  <pre><code>   CREATE TABLE `vpVideo` (
    `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `userID` int(11) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `createDate` bigint(20) DEFAULT NULL,
    `vidExists` varchar(1) DEFAULT 'N',
    PRIMARY KEY (`ID`)
  ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>When I do <code>.read database.sql</code> I get</p>
  
  <p><code>Error: near line 1: near "unsigned": syntax error</code></p>
  
  <hr>
  
  <p>So I took out the <code>unsigned</code> and the <code>ENGINE=myISAM</code> stuff, as well as the <code>AUTO_INCREMENT</code>  and now It seems to work. </p>
  
  <p>At least it doesn't throw errors when I do <code>.read</code></p>
  
  <p>So I think it worked. Can I view a file somewhere to see the result?</p>