Re: [sqlite] table backup

2012-12-12 Thread dd
gt; >> >> >> -Original Message- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dd >> Sent: Tuesday, December 11, 2012 1:00 AM >> To: General Discussion of SQLite Database >> Subject: Re: [sq

Re: [sqlite] table backup

2012-12-12 Thread dd
r the error > locally much more quickly with stack protection on then in a random system. > > > > > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dd > Sent: Tuesday, December 11, 2012 1:00 AM

Re: [sqlite] table backup

2012-12-11 Thread Simon Slavin
On 11 Dec 2012, at 6:00pm, Roger Binns wrote: > Chances are that whatever corrupts your databases would also corrupt the > backups. Here is something the Windows team found: > > http://blogs.msdn.com/b/oldnewthing/archive/2005/04/12/407562.aspx Right. I don't have experience with motherboar

Re: [sqlite] table backup

2012-12-11 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/12/12 03:46, dd wrote: > But in customers place, I am getting corruptions. Chances are that whatever corrupts your databases would also corrupt the backups. Here is something the Windows team found: http://blogs.msdn.com/b/oldnewthing/archiv

Re: [sqlite] table backup

2012-12-11 Thread Michael Black
eral Discussion of SQLite Database Subject: 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 cr

Re: [sqlite] table backup

2012-12-11 Thread Simon Slavin
On 11 Dec 2012, at 11:46am, dd wrote: > I tested with millions of records. Sqlite is stable and reliable. It is > suitable for my application. So, I have chosen. > But in customers place, I am getting corruptions. Within 6 months I got 4 > corruptions. That is a good test. My conclusion is tha

Re: [sqlite] table backup

2012-12-11 Thread dd
I tested with millions of records. Sqlite is stable and reliable. It is suitable for my application. So, I have chosen. But in customers place, I am getting corruptions. Within 6 months I got 4 corruptions. I do integrity check when app launch. But, critical data is there with corrupted database. H

Re: [sqlite] table backup

2012-12-11 Thread Simon Slavin
On 11 Dec 2012, at 7:00am, dd wrote: > 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 w

Re: [sqlite] table backup

2012-12-11 Thread Hick Gunter
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

Re: [sqlite] table backup

2012-12-10 Thread dd
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

Re: [sqlite] table backup

2012-12-10 Thread Roger Binns
-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.sq

Re: [sqlite] table backup

2012-12-09 Thread Hick Gunter
durga.d...@gmail.com] Gesendet: Montag, 10. Dezember 2012 06:45 An: General Discussion of SQLite Database Betreff: Re: [sqlite] table backup Sometimes, sqlite databse corrupts. So, I want to take online backup of specific table. Not entire database. Any best solution? On Sun, Dec 9, 2012 at 11:29 PM

Re: [sqlite] table backup

2012-12-09 Thread dd
Sometimes, sqlite databse corrupts. So, I want to take online backup of specific table. Not entire database. Any best solution? On Sun, Dec 9, 2012 at 11:29 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 09/12/12 10:35, dd wrote: > > i mean, for every write oper

Re: [sqlite] table backup

2012-12-09 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/12/12 10:35, dd wrote: > i mean, for every write operation in a table. You should specify some of your other constraints and exactly what it is you are trying to achieve (*not* how you are trying to achieve it). The solutions range from impleme

Re: [sqlite] table backup

2012-12-09 Thread dd
i mean, for every write operation in a table. On Sun, Dec 9, 2012 at 11:55 PM, dd wrote: > Hi All, > > What is the best way to do online backup for a particular table for > every write operation in a sqlite db. Not entire database. > > Best Regards, > d > _

[sqlite] table backup

2012-12-09 Thread dd
Hi All, What is the best way to do online backup for a particular table for every write operation in a sqlite db. Not entire database. Best Regards, d ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinf