On 2 Mar 2012, at 10:45pm, Steffen Mangold <steffen.mang...@balticsd.de> wrote:
> I now delete the malform message and the rollback command from the *.sql file > and run ".read". Okay ... > Sqlite shell runs complete and the shell ask me for new command "> " (DB file > seems to have the right size. > I'm happy now and enter command ".exit" and bam Db file has 0kb?!?!? > What have i done wrong? Any Commit command or something? By all means enter 'COMMIT;' as a command after your '.read' has finished. Worst it can do is issue an error message. Hmm. Yes, if the file you read contains a BEGIN and then a ROLLBACK then the shell tool may not have the logic to realise that the end of the file means there should probably be a COMMIT somewhere. Then, before your '.exit' command, try a '.tables' command and see if the database now has tables in. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
