ibdata1 lost

2009-05-27 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:

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) ? (MySQL

RE: ibdata1 lost

2009-05-27 Thread Andrew Braithwaite
-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.26) Thanks

Re: ibdata1 lost

2009-05-27 Thread Sebastien MORETTI
...@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 For list archives

Re: ibdata1 lost

2009-05-27 Thread ewen fortune
Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI sebastien.more...@unil.ch 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

Re: ibdata1 lost

2009-05-27 Thread Sebastien MORETTI
Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI sebastien.more...@unil.ch 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

Re: ibdata1 lost

2009-05-27 Thread ewen fortune
Sebastien, On Wed, May 27, 2009 at 11:35 AM, Sebastien MORETTI sebastien.more...@unil.ch 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

Re: ibdata1 lost

2009-05-27 Thread Sebastien MORETTI
Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI sebastien.more...@unil.ch 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