> Your data is gone (unless you can undelete it from whatever filesystems you're
I think it's too late for this, because the MySQL server has been restarted.
> You should be able to recover the schema from the directories and .frm files by doing
> something like this hack:
> 1. Take a copy of your .frm files and keep them somewhere safe.
> 2. Create a database with tables of same name as the XXX.frm files. Just make the
> tables with one column and don't put any data in them.
> 3. Stop the mysqld and replace the newly created .frm files with saved .frm files
> 4. Start mysqld and the tables should be replaced with the old ones but with no
Thanks for the schema.
But the main problem is the data. The generation process was near
completion when we lost ibdata1 file. So, no dump.
> -----Original Message-----
> From: Sebastien MORETTI [mailto:sebastien.moretti@stripped]
> Sent: 27 May 2009 07:41
> To: mysql@stripped
> Subject: ibdata1 lost
> Is there a way to recover data and/or database schema when ibdata1 file
> has been removed (for InnoDB databases) ?
> (MySQL 5.0.26)