Hi, A strategy I use when the app is likely to collect a lot of (valuable) data & store it in an sqlite db is to also keep a log of each inserted row or transaction in separate files.
In my case I create an additional xml file for each db transaction or table row, if the db file gets corrupted I can recreate & reload it from the log of individual xml files. Regards On Saturday, November 9, 2013 6:48:00 AM UTC+11, Nathan wrote: > > > > On Thursday, November 7, 2013 10:58:03 PM UTC-8, gjs wrote: >> >> Hi, >> >> Ask the customer if he/she runs some sort of file back up / sync / virus >> app & maybe ask them to rename the .back to .db & see if that fixes the >> issue. >> > > >> The issue could be due to any number of things even arising from >> attempting to copy or sync files via a PC (blame Windows ;-) >> >> Those are the things I suspect. > > > >> A general suggestion is to get the app to detect missing db file on >> startup & recreate it. >> > > That would work if it were static. If it contains 2GB of valuable customer > data, that is another story. > > Nathan > > >> >> >> On Friday, November 8, 2013 10:01:47 AM UTC+11, Nathan wrote: >>> >>> No ideas? I'm completely lost. >>> >>> On Monday, October 28, 2013 4:04:19 PM UTC-7, Nathan wrote: >>>> >>>> Not that I have reproduced it here, but . .. >>>> >>>> Customer reports that some large db files were missing from storage and >>>> were replaced by a .back file of the same approximate size. >>>> >>>> Nothing in my code ever renames a .db file to a .back file. >>>> >>>> Is there some system process that would do that? >>>> >>>> Nathan >>>> >>> -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en --- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
