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 >
