Import .sql file to sqlite

Yesterday , I had a problem. SQLite Manager with firefox 20 can’t import file any more. So, my .sql file that export from MySQL can’t import it. So, only way to use sqlite3 console.

In console , you can use like following

sqlite > .read import.sql

If you don’t want console , you can use following command in terminal

cat import.sql | sqlite3 mysqliteDB.db
comments powered byDisqus