MySQL Forums
Forum List  »  InnoDB

mysql corrupt
Posted by: Shivesh jaiswal
Date: February 12, 2014 07:51AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql corrupt
2445
February 12, 2014 07:51AM


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.