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. key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=151 threads_connected=1 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. thd: 0x3c5e698 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... 014A0D63 mysqld.exe!?max_supported_key_length@handler@@UBEIXZ() 014A47F7 mysqld.exe!?max_supported_key_length@handler@@UBEIXZ() 014A4BA6 mysqld.exe!?max_supported_key_length@handler@@UBEIXZ() 014A4BB4 mysqld.exe!?max_supported_key_length@handler@@UBEIXZ() 013138FC mysqld.exe!??? 77C63A7E ntdll.dll!RtlFreeHeap() 015572AD mysqld.exe!my_xml_error_string() 015572AD mysqld.exe!my_xml_error_string() FF7405E8 8BC359FF EC8B55FF 08758B56 A80C468B A81E7483 FF1A7408 BAE80876 81FFDBC5 FBF70C66 C033FFFF 89068959 46890846 C35D5E04 8B55FF8B 8B5151EC 33530C45 3B5756DB E1840FC3 38000000 D9840F18 8B000000 5D223035 085D3901 53535B75 D6FF5053 1375C33B 227C15FF E850015D FFDBB90E BDE9C033 8B000000 F83B107D F88B0277 76FFFF83 InitAtomTable() B8CEE812 00C7FFDB 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` thd->thread_id=30 thd->killed=NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains 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