Sorry, Microsoft SQL!
From: "Panos Tsapralis" <[EMAIL PROTECTED]>
Sent: Wednesday, November 08, 2006 6:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Undelete a droped table
I suppose you
os Tsapralis" <[EMAIL PROTECTED]>
*Sent*: Tuesday, November 07, 2006 1:10 PM
*To*: "Eric Lommatsch" <[EMAIL PROTECTED]>
*Subject*: Re: Undelete a droped table
Eric, as far as SQL is concerned, there is no way to recover dropped
tables
and, to my knowledge, there is no MYS
<[EMAIL PROTECTED]>
Subject: Re: Undelete a droped table
Eric, as far as SQL is concerned, there is no way to recover dropped tables
and, to my knowledge, there is no MYSQL-specific way to do that either, so,
your only hope is to have a rather fresh backup of your database.
BTW, this gives
>On 11/7/06, Eric Lommatsch <[EMAIL PROTECTED]> wrote:
>>I have accidently droped a table from one of my database's. The table was
>>an innodb table. Is there anyway that I can recover the table or is that
>>information gone for good if I don't have a current backup of that table?
At 11:09 PM 11/
Eric, as far as SQL is concerned, there is no way to recover dropped tables
and, to my knowledge, there is no MYSQL-specific way to do that either, so,
your only hope is to have a rather fresh backup of your database.
BTW, this gives me an idea: I suppose that dropping a database table is a
two-t
There is only ONE SLIM HOPE.
Is your binary logging enabled ???
If yes, how far back ??
You could theoretically recreate the table from the binary logs
up to the moment just before you accidentally dropped the table
if the binary logs contain the moment you first created the table
along with all
Only if you had enabled the "log" or "bin-log" options, and the log's
history contains the information you need (depending on the log's
creation date).
Carlos
On 11/7/06, Eric Lommatsch <[EMAIL PROTECTED]> wrote:
Hello,
I have accidently droped a table from one of my database's. The table was
