Thanks for answer. I can do integrity check by PRAGMA integrity_check.Please correct me if i wrong. Here backup means copying database file OR we can create query to SQLite for backup or copy.
Cheers- Techi On Wed, Jul 17, 2013 at 4:42 PM, Paolo Bolzoni < [email protected]> wrote: > On Wed, Jul 17, 2013 at 12:55 PM, techi eth <[email protected]> wrote: > > 2) How do we make database safe from these error Or What is > Possibility to > > access database after error. > After error, as Stephan said you are out of luck. > > You should avoid this errors in the first place: > - make backup often, > - keep the safety features of sqlite3 on, > - use a error resilient filesystem (e.g., zfs), > - use ecc memory. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
