Fix MySQL server crash

5 posts in this topic

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!

1 person likes this

Share this post

Link to post
Share on other sites

#2 ·  Posted (edited)

I am sure somebody will jump in here soon to promote that miracle product solving all you troubles... lets see how long that takes.


Edited by Jos
1 person likes this

Visit the SciTE4AutoIt3 Download page for the latest versions  - Beta files                                How to post scriptsource        Forum Rules
Live for the present,
Dream of the future,
Learn from the past.

Share this post

Link to post
Share on other sites

#3 ·  Posted (edited)


Please do not bother to reply to this - it is a good example of an "astroturf" thread, the like of which we get now and again. We just wait a few days until another first-time poster appears with a possible solution (which just happens to include embedded links to their software) and then we can ban them both.


Edit: I see Jos had the same thoughts!

Edited by Melba23
1 person likes this

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:


ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area


Share this post

Link to post
Share on other sites

Thank you guys for your feedback and help. Sorry, that long time did not respond. This is because the issue was solved and I forgot to tell.) Thank you!

Share this post

Link to post
Share on other sites
This topic is now closed to further replies.