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
-0500 US/Eastern
Subject: Undelete a droped table
Hello,
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?
Thank you
Er
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
Hello,
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?
Thank you
Eric H. Lommatsch
Programmer
MICRONix, Inc.
2087 South
