Importing .sql file into SQLite

sql sqlite

That file is a MySQL dump.To make SQLite understand it, you have to:

delete COMMENTs on the table fields;
remove AUTO_INCREMENT from id (INTEGER PRIMARY KEY fields are autoincrementing in SQLite anyway);
remove ENGINE and DEFAULT CHARSET;
remove LOCK/UNLOCK commands;
make the INSERT commands have fewer records;
replace \' quoting with ''.

sql sqlite

That is a MySQL Dump and not SQLite.

There are slight variations on the syntax.