Entire sqlite database wiped of data??

[Bob Sneidar]

Richard, barring anything your app could have done to wipe the data, and barring a damaged database file (a possibility if the physical media took a hit) there is only one thing left. Someone hacked into your database and altered the data. How is your app accessing the data? Is the access to the database encrypted? 

One of the common ways that SQL databases are backed up is by dumping the entire database to a text file or series of text files, separate for each time you backup so you don't overwrite good data with bad. Virtually all SQL databases have a way to do this (not sure about sqLite though). For any commercial product, this is a must have feature. Everyone expects some kind of backup to be included. 

Bob


On Oct 3, 2012, at 5:08 PM, Dr. Hawkins wrote:

> On Wed, Oct 3, 2012 at 9:49 AM, Bob Sneidar <bobs at twft.com> wrote:
>> I take it you have viewed the data in an SQL utility? Firefox has an sqLite plugin that works pretty well and it's free. Without opening
>> your database myself, I can't do much to help.
> 
> Unfortunately, it's client data.
> 
> On Wed, Oct 3, 2012 at 11:15 AM, Peter Haworth <pete at lcsql.com> wrote:
>> There is no sqlite single command to clear out all the data in all tables.
> 
> That's what I thought . . .
> 
>> If the keys are still there and you can see the data in binary mode then
>> I'd guess something in your program is not working correctly.  Try using
>> one of the many sqlite admin tools out there to see if it sees the data.
> 
> I've manually queried the database from the message box--the columns &
> keys remain, but the data is gone (but visible in less).
> 
> And as for backup . . . I managed to kill wuala's time-travel,
> apparently, by renaming the file--now neither the file with it's new
> name nor the file assigned to the original name has a history.
> 
> And it wasn't entered long enough to be in other backups.
> 
> It's not a lot to reenter; I'm more concerned with *how* multiple
> tables could get whacked like that; I *think* the program should have
> failed with the first one gone . . .
> 
> 
> -- 
> Richard E. Hawkins, Esq.
> (702) 508-8462
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode