Sorry, but the virtual table extensions I have written are all proprietary.
Gunter -----Ursprüngliche Nachricht----- Von: dd [mailto:durga.d...@gmail.com] Gesendet: Dienstag, 11. Dezember 2012 08:00 An: General Discussion of SQLite Database Betreff: Re: [sqlite] table backup Hi Roger, I don't have any clue. Two databases are corrupted. First one, while inserting 20,000 records suddenly sqlite thrown disk io error at 4,000 record. No clue. Second database corrupted when my application crashed. But that time, second database was not opened. So, I am planning to choose backup solution instead of investigating corruption. I discussed this issue in my previous post. Any sample application for virtual table option. Best Regards, d On Mon, Dec 10, 2012 at 9:09 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 09/12/12 21:44, dd wrote: > > Sometimes, sqlite databse corrupts. > > That is the problem you need to fix. If you have a system that is > unreliable then it will also corrupt your backups. > > http://www.sqlite.org/lockingv3.html#how_to_corrupt > http://www.sqlite.org/howtocorrupt.html > > > So, I want to take online backup of specific table. Not entire > > database. > > Do you need to take a backup on every change, as part of the change or is > it acceptable to make backups periodically and possibly lose intermediate > versions of the data? > > For a periodic backup you can iterate over the table contents and output > them in a convenient format for you, such as CSV or SQL statements. > > For saving all data you can use triggers to save historical values in a > second table and then do a periodic backup. > > If it must be immediate then the only choice available is to use a virtual > table and do the backup during writes/sync. > > This is all considerably more work than figuring out why you are getting > corruption in the first place. > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iEYEARECAAYFAlDGF2IACgkQmOOfHg372QTo9gCfSQQwreSvsa9lrV/wj0YC2Fvj > LT0AmwdZSaNvVJJuic3gLYmQfn9YX6x3 > =Gx1r > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users