Re: ibdata1 lost

2009-05-27 Thread Sebastien MORETTI
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

2009-05-27 Thread ewen fortune
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

2009-05-27 Thread Sebastien MORETTI
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

2009-05-27 Thread ewen fortune
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

2009-05-27 Thread Sebastien MORETTI
:sebastien.more...@unil.ch] Sent: 27 May 2009 07:41 To: mysql@lists.mysql.com Subject: ibdata1 lost Hi, Is there a way to recover data and/or database schema when ibdata1 file has been removed (for InnoDB databases) ? (MySQL 5.0.26) Thanks -- Sébastien Moretti -- MySQL General Mailing List Fo

RE: ibdata1 lost

2009-05-27 Thread Andrew Braithwaite
a. Andrew -Original Message- From: Sebastien MORETTI [mailto:sebastien.more...@unil.ch] Sent: 27 May 2009 07:41 To: mysql@lists.mysql.com Subject: ibdata1 lost Hi, Is there a way to recover data and/or database schema when ibdata1 file has been removed (for InnoDB databases) ? (MySQL 5.0.

Re: ibdata1 lost

2009-05-27 Thread Johan De Meersman
* 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

ibdata1 lost

2009-05-26 Thread Sebastien MORETTI
Hi, Is there a way to recover data and/or database schema when ibdata1 file has been removed (for InnoDB databases) ? (MySQL 5.0.26) Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsu