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

Reply via email to