-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 06/17/2010 01:50 PM, Simon Slavin wrote: > Sometimes it's best to use the command-line tool to dump the data to a file > of SQL commands,
The command line tool needs its code fixing first: http://www.sqlite.org/src/tktview?name=2466653295 In particular look for "dump" (including quotes) in shell.c and then examine the error handling. Basically errors are silently ignored. In SQLITE_CORRUPT cases a table iteration is retried in reverse rowid order. This means you will not know if dump failed or has only given you some of the data. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkwaj68ACgkQmOOfHg372QQvOwCghNVGYHWUrnYTGPCscTAfKyRC VbIAoKDwBFFosOaTCvtXktJdVwZrybdn =EN8y -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
