Re: Restoring database with frm myi and myd

2007-12-17 Thread To Glace
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/DATA

Restoring database with frm myi and myd

2007-12-17 Thread To Glace
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 c