List:General Discussion« Previous MessageNext Message »
From:Andrew Braithwaite Date:May 27 2009 9:11am
Subject:RE: ibdata1 lost
View as plain text  
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 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 data.

Andrew

-----Original Message-----
From: Sebastien MORETTI [mailto:sebastien.moretti@stripped] 
Sent: 27 May 2009 07:41
To: mysql@stripped
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: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
ibdata1 lostSebastien MORETTI27 May
  • Re: ibdata1 lostJohan De Meersman27 May
  • RE: ibdata1 lostAndrew Braithwaite27 May
    • Re: ibdata1 lostSebastien MORETTI27 May
      • Re: ibdata1 lostewen fortune27 May
        • Re: ibdata1 lostSebastien MORETTI27 May
          • Re: ibdata1 lostewen fortune27 May
          • Re: ibdata1 lostSebastien MORETTI27 May