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

Reply via email to