Re: delete after undo

2002-03-07 Thread John Hunter
> "Joel" == Joel Rees <[EMAIL PROTECTED]> writes: Joel> This begins to sound like a job for Perl. Of course, it Joel> would be nice if you could get someone familiar with the Joel> internal formats mysql uses to give you some hints Yes, I am having trouble deciphering the primary

Re: delete after undo

2002-03-07 Thread Joel Rees
John Hunter asked: > Before I give up hope entirely, I notice that the file > mysql/var/seizure/surgery.MYD is not empty, and has the values from > the table before the delete in it. Although it is a binary file, > because it has large text fields I can read enough of it with 'less' > to see tha

Re: delete after undo

2002-03-07 Thread John Hunter
> "Paul" == Paul DuBois <[EMAIL PROTECTED]> writes: Paul> You can undo them using your backup. Otherwise, no. Well, since my backup is a couple of weeks old, this bites. Before I give up hope entirely, I notice that the file mysql/var/seizure/surgery.MYD is not empty, and has the value

Re: delete after undo

2002-03-07 Thread Paul DuBois
At 21:05 -0600 3/7/02, John Hunter wrote: >I just did > >delete from some_table where 1>0; > >when I wanted to do > >delete from some_table where pid=1234; > >Oops! > >Nothing else has been done to the database since then. Can I undo or >not commit these changes? You can undo them using your bac

delete after undo

2002-03-07 Thread John Hunter
I just did delete from some_table where 1>0; when I wanted to do delete from some_table where pid=1234; Oops! Nothing else has been done to the database since then. Can I undo or not commit these changes? I am sure this is a FAQ, but I am in a panic so I would be much obliged if someone can