Undelete Data

------=_NextPart_000_002D_01C5395A.D7D02730
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

I have searched the web but didn't found what I'm looking for
:-( Is there any way how to undelete data from MySQL MyISAM database deleted
with DELETE command? My site got hacked due the stupid in one fucking stupid
software we use and 40.000 posts where deleted from the DB :-(. I tried some
recovery softwares like www.officerecovery.com/mysql but it didn't help. Any
suggestions guys? Thanks for any help.



Milan


------=_NextPart_000_002D_01C5395A.D7D02730--

Re: Undelete Data

Good and regular backups are an important part of managing any database.

On Mon, 4 Apr 2005 21:11:17 +0200, "Milan Reznicek"
said:
> Hi,
>
> I have searched the web but didn't found what I'm looking for
> :-( Is there any way how to undelete data from MySQL MyISAM database
> deleted
> with DELETE command? My site got hacked due the stupid in one fucking
> stupid
> software we use and 40.000 posts where deleted from the DB :-(. I tried
> some
> recovery softwares like www.officerecovery.com/mysql but it didn't help.
> Any
> suggestions guys? Thanks for any help.
>
>
>
> Milan
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Undelete Data

If you don't have a backup of your DB I believe there is no way to
recover your data. If you use a service provider as DB server, they
may have a backup, ask them for it. If you run the server yourself and
never worried about backing up your data, its gone.I don't believe
MySQL has any way of getting deleted stuff back from myisam tables.

Sorry, but this may be a warning for everyone, BACKUP your data! In
one, two, ten different ways, you may need it someday. (I say that
because I was almost fired from my previous job because of a ruined
HD, and thank God I had a bck).

On Apr 4, 2005 4:11 PM, Milan Reznicek wrote:
> Hi,
>
> I have searched the web but didn't found what I'm looking for
> :-( Is there any way how to undelete data from MySQL MyISAM database deleted
> with DELETE command? My site got hacked due the stupid in one fucking stupid
> software we use and 40.000 posts where deleted from the DB :-(. I tried some
> recovery softwares like www.officerecovery.com/mysql but it didn't help. Any
> suggestions guys? Thanks for any help.
>
>
> Milan
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Undelete Data

Hope you've got a backup copy! If you have logging turned on, you may be ab=
le to rollback the transaction.

Generally speaking, when a row is deleted, it's gone.

Randy Clamons
Systems Programming
Novaspace.com


> ------------Original Message------------
> From: "Milan Reznicek"
> To: win32@lists.mysql.com
> Date: Mon, Apr-4-2005 12:11 PM
> Subject: Undelete Data
>
> Hi,
> =

> I have searched the web but didn't found what I'm looking =

> for
> :-( Is there any way how to undelete data from MySQL MyISAM database =

> deleted
> with DELETE command? My site got hacked due the stupid in one fucking =

> stupid
> software we use and 40.000 posts where deleted from the DB :-(. I tried =

> some
> recovery softwares like www.officerecovery.com/mysql but it didn't =

> help. Any
> suggestions guys? Thanks for any help.
> =

> =

> =

> Milan
> =

> =



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Undelete Data

I don't believe there's such a thing as "delete" flag, once you delete
something, its really gone, I tried cleaning a test database of 1mb
and the file instantly decreased from 1mb to some kb, so, delete
really DELETE stuff.

Now, changing the subject, if you have a important app that deals with
data, a good way to keep your DB secure is to never grant delete
permissions to the user that access from the web or uses the client
app, instead, create a flag field, like "status_" and change it to "0"
when you "pseudo-delete" something. This way you'll never loose data
for lack of security. And, from times to times you can backup all "0"
flagged data and delete it!

On Apr 4, 2005 4:30 PM, Milan Reznicek wrote:
> Firtsly - i know i should backup - but the fucking friend who runs the
> server didn't do the copy of the backup so it got rewritten the other day
> with an empty DB (what a fucking stupid idiot - he went to cottage with a
> girl a didn't answer the phone whole weekend and then said I'm sorry but
> there no useful backup now :((((((((((((((((((( )
>
> Next - i think that everything should be in the DB (it did not got
> truncated) - but with a deletion flag - if anyone had tried to do the
> "undeletion" before i would be really appreciated if he will able to help
> me.
>
> Milan
>
> -----Original Message-----
> From: win32-return-16844-reznicek=espace.cz@lists.mysql.com
> [mailto:win32-return-16844-reznicek=espace.cz@lists.mysql.co m] On Behalf Of
> Daniel da Veiga
> Sent: Monday, April 04, 2005 9:22 PM
> To: MySQL Win32 List
> Subject: Re: Undelete Data
>
> If you don't have a backup of your DB I believe there is no way to
> recover your data. If you use a service provider as DB server, they
> may have a backup, ask them for it. If you run the server yourself and
> never worried about backing up your data, its gone.I don't believe
> MySQL has any way of getting deleted stuff back from myisam tables.
>
> Sorry, but this may be a warning for everyone, BACKUP your data! In
> one, two, ten different ways, you may need it someday. (I say that
> because I was almost fired from my previous job because of a ruined
> HD, and thank God I had a bck).
>
> On Apr 4, 2005 4:11 PM, Milan Reznicek wrote:
> > Hi,
> >
> > I have searched the web but didn't found what I'm looking for
> > :-( Is there any way how to undelete data from MySQL MyISAM database
> deleted
> > with DELETE command? My site got hacked due the stupid in one fucking
> stupid
> > software we use and 40.000 posts where deleted from the DB :-(. I tried
> some
> > recovery softwares like www.officerecovery.com/mysql but it didn't help.
> Any
> > suggestions guys? Thanks for any help.
> >
> >
> > Milan
> >
> >
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=reznicek@espace.cz
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Undelete Data

Yes I know all this stuff, but you know that when you are working you don't
have nearly any time for other things. So running www.phpbb.com as bulletion
board was the easiest way to do it. Dut know i'm looking for any other board
'cause this one really sucks. If i would meet the idiot who had programmed
it, you can bet i would "kill" him ;). In any application I work on in work
we surelly use status instead of really deleting the rows.

But i don't know why your DB gets truncated and mine not - mine is still
65MB "big" and I think i wouldn't be truncated till i run OPTIMIZE TABLE on
the table in it.

Milan

P.S.
To everyone :) -> don't trust any admin - make your backup, because admins
are awful people who'd rather fuck young girls than keep your backups safe
;)

P.S2.
I hope the users will fill in the board very quickly so they won't miss the
stuff we've lost after three years :)

-----Original Message-----
From: win32-return-16847-reznicek=espace.cz@lists.mysql.com
[mailto:win32-return-16847-reznicek=espace.cz@lists.mysql.co m] On Behalf Of
Daniel da Veiga
Sent: Monday, April 04, 2005 9:40 PM
To: MySQL Win32 List
Subject: Re: Undelete Data

I don't believe there's such a thing as "delete" flag, once you delete
something, its really gone, I tried cleaning a test database of 1mb
and the file instantly decreased from 1mb to some kb, so, delete
really DELETE stuff.

Now, changing the subject, if you have a important app that deals with
data, a good way to keep your DB secure is to never grant delete
permissions to the user that access from the web or uses the client
app, instead, create a flag field, like "status_" and change it to "0"
when you "pseudo-delete" something. This way you'll never loose data
for lack of security. And, from times to times you can backup all "0"
flagged data and delete it!

On Apr 4, 2005 4:30 PM, Milan Reznicek wrote:
> Firtsly - i know i should backup - but the fucking friend who runs the
> server didn't do the copy of the backup so it got rewritten the other day
> with an empty DB (what a fucking stupid idiot - he went to cottage with a
> girl a didn't answer the phone whole weekend and then said I'm sorry but
> there no useful backup now :((((((((((((((((((( )
>
> Next - i think that everything should be in the DB (it did not got
> truncated) - but with a deletion flag - if anyone had tried to do the
> "undeletion" before i would be really appreciated if he will able to help
> me.
>
> Milan
>
> -----Original Message-----
> From: win32-return-16844-reznicek=espace.cz@lists.mysql.com
> [mailto:win32-return-16844-reznicek=espace.cz@lists.mysql.co m] On Behalf
Of
> Daniel da Veiga
> Sent: Monday, April 04, 2005 9:22 PM
> To: MySQL Win32 List
> Subject: Re: Undelete Data
>
> If you don't have a backup of your DB I believe there is no way to
> recover your data. If you use a service provider as DB server, they
> may have a backup, ask them for it. If you run the server yourself and
> never worried about backing up your data, its gone.I don't believe
> MySQL has any way of getting deleted stuff back from myisam tables.
>
> Sorry, but this may be a warning for everyone, BACKUP your data! In
> one, two, ten different ways, you may need it someday. (I say that
> because I was almost fired from my previous job because of a ruined
> HD, and thank God I had a bck).
>
> On Apr 4, 2005 4:11 PM, Milan Reznicek wrote:
> > Hi,
> >
> > I have searched the web but didn't found what I'm looking
for
> > :-( Is there any way how to undelete data from MySQL MyISAM database
> deleted
> > with DELETE command? My site got hacked due the stupid in one fucking
> stupid
> > software we use and 40.000 posts where deleted from the DB :-(. I tried
> some
> > recovery softwares like www.officerecovery.com/mysql but it didn't help.
> Any
> > suggestions guys? Thanks for any help.
> >
> >
> > Milan
> >
> >
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=reznicek@espace.cz
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=reznicek@espace.cz


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Undelete Data

The other thing that can be done on the design side is to build a
database that never deletes. This can be done by providing a status
flag, with values like Active or Inactive. It's useful to provide a
timestamp, too, which gets updated whenever the record is touched.
Then, when the record is indicated as "deleted", the record is marked
"Inactive". Queries against the database have an additional

... AND status = 'A'

component in their WHERE clause.

This way, you not only protect the data, you have a history, and if the
database gets large, records can be moved to archive tables and when
necessary offline.

This is good for debugging and for robustness.

Just an idea.

-jtg

On Mon, 4 Apr 2005 16:39:49 -0300, "Daniel da Veiga"
said:
> I don't believe there's such a thing as "delete" flag, once you delete
> something, its really gone, I tried cleaning a test database of 1mb
> and the file instantly decreased from 1mb to some kb, so, delete
> really DELETE stuff.
>
> Now, changing the subject, if you have a important app that deals with
> data, a good way to keep your DB secure is to never grant delete
> permissions to the user that access from the web or uses the client
> app, instead, create a flag field, like "status_" and change it to "0"
> when you "pseudo-delete" something. This way you'll never loose data
> for lack of security. And, from times to times you can backup all "0"
> flagged data and delete it!
>
> On Apr 4, 2005 4:30 PM, Milan Reznicek wrote:
> > Firtsly - i know i should backup - but the fucking friend who runs
> > the server didn't do the copy of the backup so it got rewritten the
> > other day with an empty DB (what a fucking stupid idiot - he went
> > to cottage with a girl a didn't answer the phone whole weekend and
> > then said I'm sorry but there no useful backup now
> > :((((((((((((((((((( )
> >
> > Next - i think that everything should be in the DB (it did not got
> > truncated) - but with a deletion flag - if anyone had tried to do
> > the "undeletion" before i would be really appreciated if he will
> > able to help
> > me.
> >
> > Milan
> >
> > -----Original Message----- From: win32-return-16844-
> > reznicek=espace.cz@lists.mysql.com [mailto:win32-return-16844-
> > reznicek=espace.cz@lists.mysql.com] On Behalf Of Daniel da Veiga
> > Sent: Monday, April 04, 2005 9:22 PM To: MySQL Win32 List Subject:
> > Re: Undelete Data
> >
> > If you don't have a backup of your DB I believe there is no way to
> > recover your data. If you use a service provider as DB server, they
> > may have a backup, ask them for it. If you run the server yourself
> > and never worried about backing up your data, its gone.I don't
> > believe MySQL has any way of getting deleted stuff back from myisam
> > tables.
> >
> > Sorry, but this may be a warning for everyone, BACKUP your data! In
> > one, two, ten different ways, you may need it someday. (I say that
> > because I was almost fired from my previous job because of a ruined
> > HD, and thank God I had a bck).
> >
> > On Apr 4, 2005 4:11 PM, Milan Reznicek wrote:
> > > Hi,
> > >
> > > I have searched the web but didn't found what I'm
> > > looking for
> > > :-( Is there any way how to undelete data from MySQL MyISAM
> > > :database
> > deleted
[snip]

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Undelete Data

--
Chuck


A vulture boards an airplane, carrying two

dead raccoons. The stewardess looks at him

and says, "I'm sorry, sir, only one carrion allowed per passenger."
It is a little late now, but what I have done is created a duel database;

One table is the one everyone views

Second table is duplicate of first until edits are made;
When they are satisfied with edits there is a built in function to transfer
that revised table to the viewable table. This is in one database.

In the directory tree there are two complete databases;

The one that everyone views and the maintainer can edit.

When I get a notice he has edited an updated I back it up to the second
database in separate directory.

It might be over kill but I have been there loosing one and this was my
approach...

Chuck



-----Original Message-----
From: Jan Theodore Galkowski [mailto:jtgalkowski@alum.mit.edu]
Sent: Monday, April 04, 2005 2:22 PM
To: Milan Reznicek; win32@lists.mysql.com
Subject: Re: Undelete Data

Good and regular backups are an important part of managing any database.

On Mon, 4 Apr 2005 21:11:17 +0200, "Milan Reznicek"
said:
> Hi,
>
> I have searched the web but didn't found what I'm looking for
> :-( Is there any way how to undelete data from MySQL MyISAM database
> deleted
> with DELETE command? My site got hacked due the stupid in one fucking
> stupid
> software we use and 40.000 posts where deleted from the DB :-(. I tried
> some
> recovery softwares like www.officerecovery.com/mysql but it didn't help.
> Any
> suggestions guys? Thanks for any help.
>
>
>
> Milan
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=crmabbott@comcast.net


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org