Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Feb 12 at 22:34

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.