Felipe Lopes wrote: >Hi there! > >I am trying to import a csv file (ip-to-country to be especific) to a table >on sqlite db...It has 50000+ lines. Tried to use php and it takes like 10 >minutes loading and returns that the database is locked...When I take a look >at the table, it has only 9000 entries... >I would like to know how can I import this csv file to sqlite, either w/ php >or command line. If thru command line is the only way, some explanation on >what should I get to have it working on my debian is welcome.
Make sure you do your inserts in a transaction. Bertrand Mansion Mamasam