I have mysql database using xampp in my widows system. its got currupt after power failure i have back of database before 2 days but i dont have backup of one day transactions. now i tried innodb_force_recovery = 6 and i am able to start mysql server and also able to run phpmyadmin it showing me all the database name and opening two databse but when i try to open another database it stops automatically. this the error
"140212 18:49:20 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on
InnoDB: Skipping log redo
140212 18:49:21 InnoDB: Started; log sequence number 0 0
InnoDB: !!! innodb_force_recovery is set to 6 !!!
140212 18:49:21 [Note] Event Scheduler: Loaded 0 events
140212 18:49:21 [Note] D:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.1.41' socket: '' port: 3306 Source distribution
140212 18:56:58 - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133304 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 05E17B88=SHOW TABLE STATUS FROM `card2011`
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html
information that should help you find out what is causing the crash."
Please tell me how to resolve this my ibdata1 file size is 522 mb only