I'm running SQLite 3.6.18 on Gentoo linux. The filesystem is Reiserfs, so 11 gigs should not be a problem. Here's a screen scrape...
=============================================== [d531][waltdnes][~/SQLite] ll dly04.csv -rw-r--r-- 1 waltdnes users 11143911240 Nov 27 15:34 dly04.csv [d531][waltdnes][~/SQLite] sqlite3 dlyxx.sqlite SQLite version 3.6.18 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .mode csv dly04 sqlite> .import dly04.csv dly04 cannot open file: dly04.csv sqlite> =============================================== Am I making some glaring noob error here? I've successfully imported, and tested out smaller files using the same method. The table dly04 has already been created, and it's just a matter of importing from the CSV file. Is there a known maximum line-count or file-size? If necessary, I can run "split -l <number_of_lines> dly04.csv", and import the separate (smaller) pieces. Am I correct in assuming that multiple ".import" statements will append to an existing table, rather than overwriting? (Yes, I am new to SQLite). -- Walter Dnes <waltd...@waltdnes.org> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
