Create sqlite3 database from .sql file Create sqlite3 database from .sql file sqlite sqlite

Create sqlite3 database from .sql file


Your exports is taken from a MySQL database hence the MyISAM. This will work for you

CREATE TABLE vpVideo (  ID int(11) NOT NULL,  userID int(11) DEFAULT NULL,  name varchar(255) DEFAULT NULL,  createDate bigint(20) DEFAULT NULL,  vidExists varchar(1) DEFAULT 'N',  PRIMARY KEY (ID));

AUTOINCREMENT is done automatically with the definition of your primary key

Imports between different databases only work if it is done with the SQL-92 standard. All vendors of databases extended that standard, so that SQL-92 is only a subset of the entire sqlite syntax (as it is for others like oracle, db2, mysql)