Hello,

A database which has been deleted need to be restored.
There is no .sql dump file.
All we have is the .frm, .myi and .myd files from
/var/lib/mysql/DATABASENAME.

Here are the steps I have taken:
1. Created a new empty database - NEWDB
2. individually restored all tables using the restore command:
restore table TABLENAME from '/PATH/TO/FILES';
Most displayed.. "The storage engine for the table doesn't support restore"
and only created the structure for the table and did not import the actual
data.

I am not sure where to go from here.
The data itself need to be restored back and cannot get to this at all.

Is there a different way to restore this information?
How do I enable the storage engine to support restore?

Any input would be greatly appreciated.

Thank you: TG

The db format is in "innodb"

On Dec 17, 2007 5:38 PM, To Glace <glace.formula@gmail.com> wrote:

> Hello,
>
> A database which has been deleted need to be restored.
> There is no .sql dump file.
> All we have is the .frm, .myi and .myd files from
> /var/lib/mysql/DATABASENAME.
>
> Here are the steps I have taken:
> 1. Created a new empty database - NEWDB
> 2. individually restored all tables using the restore command:
> restore table TABLENAME from '/PATH/TO/FILES';
> Most displayed.. "The storage engine for the table doesn't support
> restore"
> and only created the structure for the table and did not import the actual
> data.
>
> I am not sure where to go from here.
> The data itself need to be restored back and cannot get to this at all.
>
> Is there a different way to restore this information?
> How do I enable the storage engine to support restore?
>
> Any input would be greatly appreciated.
>
> Thank you: TG
>

glace.formula@gmail.com ("To Glace") writes:

>> A database which has been deleted need to be restored.
>> There is no .sql dump file.
>> All we have is the .frm, .myi and .myd files from
>> /var/lib/mysql/DATABASENAME.
>>
>>
>> Is there a different way to restore this information?
>> How do I enable the storage engine to support restore?
>>
> The db format is in "innodb"
>

If you were using MyISAM it could be done, but for
tables which are stored in InnoDB you are out of luck. The
data for those tables along with other name information
is stored in the ibdata file. Not sure how you 'deleted' it,
but if you don't have a stored ibdata file from when the
database was active you probably can't do anything, the
information is gone.

You mention that you have .myd files, but those
do NOT exist for tables that are of type InnoDB. InnoDB
is not a database format, it is a characteristic of each
table.

For the stuff where you do have myi,myd, and frm
files you may have good luck (on a test system) just
copying them into the directory area of another DB and they
should be usable by the server.

Hopefully you can get back to some type of system
backup that might have the innodb files.

Best regards!
--
John
__________________________________________________ _________________
John Murtari Software Workshop Inc.
jmurtari@following domain 315.635-1968(x-211) "TheBook.Com" (TM)
http://thebook.com/