On Wed, 12 Mar 2008 20:39:06 +0530, you wrote: >Hi, > >I am using the Sqlite for my server database application purpose. >I want to make sure that the database does not get corrupted. > >If by chance if i corrupts the database by what means can i restore it back?
>From a backup. Sometimes the commandline tool can recover a part: sqlite3 corrupted.db .dump | sqlite3 recovered.db >What are the various possibilities of database corrupting methods >in sqlite? so that i can try to avoid all those. http://www.sqlite.org/lockingv3.html#how_to_corrupt Of course, incorrect SQL INSERTs, DELETEs, DROPs and UPDATEs can damage your data as well. >Best Regards, >A. Sreedhar. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
