The db format is in innodb
On Dec 17, 2007 5:38 PM, To Glace [EMAIL PROTECTED] 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
