On 28 Jan 2012, at 4:45am, Antony wrote: > |CREATE TABLE trace1001_constructs ( > id INTEGER NOT NULL, > tr0000 FLOAT, > tr0001 FLOAT, > tr0002 FLOAT,
If this database is for longterm use, you're doing the wrong thing. Those should be different rows, not all one huge long row. If it's a one-off hack, then do it and get rid of it before anyone else sees it and shames you. > This is the command I intend to generate the file dump (dump.sql) from linux > shell: > > $ rm -f database.sqlite > $ sqlite3 database.sqlite < command.sql > $ sqlite3 database.sqlite ".dump" > dump.sql Do this interactively rather than as a shell script. rm database.sqlite sqlite3 database.sqlite .read command.sql Any error messages so far ? if not .dump Did that produce the right result ? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users