MySQL Forums
Forum List  »  Data Recovery

mysql server crash - recovery HELP
Posted by: Rafal Zajac
Date: May 13, 2007 10:16PM

Hi

My development server crashed recently. Unfortunately i did not have backup of my database data. Luckily the /var/lib/mysql folder was an a different partition. So i copied all the database folders to the new server and started the mysqld.

Now the problem. All the MyISAM tables seems to be ok but all the InnoDB tables are broken. MySQL Administrator says 'Table ... doesn't exist'.

When i go to the database folder i can see *.frm files but thats all (no *.MYD or *.MYI files). *.frm files are not empty co the data ist probably there just don't know how to recover it. Please help.

Ralph

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql server crash - recovery HELP
5145
May 13, 2007 10:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.