On Mon, Jun 27, 2011 at 16:15:16 +0800, baiydavid wrote:
> Thanks for you help.
>
> when an SQLITE_CORRUPT error is returned, we can use ".dump" command to
> exports the data into a sql script, and then exec this sql in a new database,
> But how to dump the data into a sql script with C programming Interface?
> Is there any other better method to solve this problem?
You shouldn't be doing automatically. When you get SQLITE_CORRUPT error, it
means something has gone very, very wrong and you should definitely
investigate what. Besides since the database is corrupt, you may not be able
to recover all data, so you have to carefuly check the dump, so again need
manual intervention.
--
Jan 'Bulb' Hudec <b...@ucw.cz>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
