FrankKelly Posted June 12, 2016 Posted June 12, 2016 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! KristofLakatos 1
Developers Jos Posted June 12, 2016 Developers Posted June 12, 2016 (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. Jos Edited June 12, 2016 by Jos FrankKelly 1 SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past.
Moderators Melba23 Posted June 12, 2016 Moderators Posted June 12, 2016 (edited) Hi, 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. M23 Edit: I see Jos had the same thoughts! Edited June 12, 2016 by Melba23 FrankKelly 1 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Reveal hidden contents ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
KristofLakatos Posted June 21, 2016 Posted June 21, 2016 You can still read this resource for more information on your issue. https://community.office365.com/en-us/f/172/t/266451 FrankKelly 1
FrankKelly Posted June 24, 2016 Author Posted June 24, 2016 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!
Recommended Posts