Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI wrote: Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You may be able to recover from the file system. So

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:35 AM, Sebastien MORETTI wrote: >>> I think it's too late for this, because the MySQL server has been >>> restarted. >> >> >> You may be able to recover from the file system. So long as you >> haven't written lots of data to the file system since the loss th

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI wrote: Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You may be able to recover from the file system. So

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI wrote: >> Hi, >> >> Your data is gone (unless you can undelete it from whatever filesystems >> you're using). > > I think it's too late for this, because the MySQL server has been restarted. You may be able to recover from the file

Re: ibdata1 lost

Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). 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

RE: ibdata1 lost

Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). 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 t

Re: ibdata1 lost

* Undelete the file * Restore from backup * Apply the infinite monkey theorem On Wed, May 27, 2009 at 8:41 AM, Sebastien MORETTI < sebastien.more...@unil.ch> wrote: > Hi, > > Is there a way to recover data and/or database schema when ibdata1 file has > been removed (for InnoDB databases) ? > > (M