I'm taking a test cut at converting a existing mysql database to sqlite. I dumped the mysql database, tweaked the prototype into slite format, and converted the escape characters in the data to standard sql format. Here's what happens when I attempt an import:
sqlite> .read proto.txt sqlite> .read city-part.sql INSERT INTO city VALUES (112.0000,7617.0000,'Hartford',41.7640,-72.6860); SQL error: unable to open database file INSERT INTO city VALUES (52.0000,6583.0000,'Eindhoven',51.4500,5.4670); SQL error: unable to open database file INSERT INTO city VALUES (13.0000,5828.0000,'Bradford',50.5480,-4.6610); SQL error: unable to open database file ... These sql errors are random. Since there's no other activity affecting this database, I wouldn't expect any contention problem. Is there something I'm missing? Oh yea, and this is EXTREMELY slow, presumably because I haven't wrapped the inserts in a transaction.
