mysql server crash - recovery HELP
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
Subject
Views
Written By
Posted
mysql server crash - recovery HELP
5181
May 13, 2007 10:16PM
3023
May 14, 2007 01:42AM
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.