: 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 me an idea: I suppose that dropping
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 MYSQL-specific way to do that either,
so,
your only hope
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 mySQL - not mSQL
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
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 an
: 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
Eric H. Lommatsch
Programmer
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
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/7/2006