Overclock.net › Forums › Software, Programming and Coding › Other Software › Fix MySQL server crash
New Posts  All Forums:Forum Nav:

Fix MySQL server crash

post #1 of 5
Thread Starter 
We recently suffered a pretty severe server crash on one of our linux machines (Fedora Core 5), which has resulted in a lot of corruption of data, unfortunately the mysql database is amongst the data which has been lost.
While we were able to get the server to boot, mysql still refuses to load. The server still produces a lot of errors on startup, so I have created a new server (Ubuntu 8.10) and copied the mysql directory across to this - but again mysql will not start.
Attached is a dump of the errors shown when running "mysqld --verbose", with the innodb_force_recovery=6 option .
Sometimes while running this check, it will pass the sanity check, while other times it will fail.
I have found plenty of articles on how to recover from a crash, but all assume that you can actually get mysql to start - which is not the case here. Additionally i have tried all innodb_force_recovery options, from 1-8, and none of them allow mysql to start.
Can anyone advise on how to go about recovering the data? If I browse the ibdata1 file I can see most of the data (there appear to be a few rows missing). Are there any tools that can read the ibdata1 file and extract data row by row?
All help greatly appreciated - as I am starting to fail my sanity check!
post #2 of 5
>>>Can anyone advise on how to go about recovering the data? If I browse the ibdata1 file I can see most of the data (there appear to be a few rows missing). Are there any tools that can read the ibdata1 file and extract data row by row?
Please don't do this... you may end up corrupting innodb data files.

It is better to follow what error log says..
"Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do
resolve it"
Just follow the steps provided in the link.. once the stack trace issue is resolved you will have exact cause for the problem and solution.
If this does not solve the problem then you can try MySql Recovery Toolbox to save the database. http://www.oemailrecovery.com/mysql_recovery.html
post #3 of 5
You can still read this resource for more information on your issue.
http://www.sqlservercentral.com/Forums/Topic1618894-2893-1.aspx
Edited by KristofLakatos - 6/25/16 at 3:10pm
post #4 of 5
Thread Starter 
I am very grateful for your advice. Thank you very much! The issue has been resolved.)
post #5 of 5
Thread Starter 
I am very grateful for your advice. Thank you very much! The issue has been resolved.)
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Fix MySQL server crash