Home » Open Source » MySQL » Recover innodb table and data using frm and ibd file (Mysql 5.5 and linux)
Recover innodb table and data using frm and ibd file [message #563249] Fri, 10 August 2012 07:22
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

Last day mysql server crashed and I am having all the table is in innodb. I am having all the folders which is needed. mysql is starting properly but when I am trying to access the tables it is show error

mysql> desc weblog;
ERROR 1146 (42S02): Table 'cmsv3.weblog' doesn't exist


I followed the doc but data is not getting recoverd.

content from the /var/log/mysqld.log file is as follows

Kindly tell me what to do now for recover this data and table.

Thanks in advance.

Pradeep

[EDITED by LF: applied [spoiler] tags]

[Updated on: Fri, 10 August 2012 07:35] by Moderator

Report message to a moderator

Previous Topic: Configure Two node mysql cluster
Next Topic: way to inserting data into a MYSQL table data in an ordered way
Goto Forum:
  


Current Time: Tue Dec 17 22:21:47 CST 2024