Re: [sqlite] rescueing data after accidental DROP

2010-06-04 Thread Simon Slavin
On 4 Jun 2010, at 3:25am, Wincent wrote: > After the DROP, a CREATE TABLE command is executed to create a table > with the same name as structure. Then some of the file which contained data from the old TABLE has probably already been overwritten. It may be that some data is already

Re: [sqlite] rescueing data after accidental DROP

2010-06-03 Thread Wincent
After the DROP, a CREATE TABLE command is executed to create a table with the same name as structure. As for the second question, I am not sure as I ask this question for a colleague instead of myself. If the payment is not too large, I think he might be willing to (still, not for sure). Regards

Re: [sqlite] rescueing data after accidental DROP

2010-06-03 Thread Simon Slavin
On 4 Jun 2010, at 2:44am, Wincent wrote: > Dear all, I am interested in the same issue as well. > Is it possible to recover data after the drop command is executed? > > I saw from the homepage it is not > (http://www.sqlite.org/lang_droptable.html), but I really hope it is > possible. Any

Re: [sqlite] rescueing data after accidental DROP

2010-06-03 Thread Wincent
Dear all, I am interested in the same issue as well. Is it possible to recover data after the drop command is executed? I saw from the homepage it is not (http://www.sqlite.org/lang_droptable.html), but I really hope it is possible. Any hints? Thank you Best On Mon, Aug 18, 2008 at 11:31 PM,

[sqlite] rescueing data after accidental DROP

2008-06-18 Thread Mario Bludau
Is there any way to recover data from a sqlite3 database file after dropping all (2) tables in it? I can see all the data including the ones that were added directly before it happened are in the db file. Is there a tool or something that can parse the file for deleted entries? Thanks for your