0

EDIT: Nbk suggested stackoverflow.com/a/46970116/5193536 which looked pretty good if I had not accidentally deleted one of the relevant files!

=========================================================================

I am on day 2 after my main notebook died. Installed XAMPP on a spare machine and all working until suddenly XAMPP refused to run MySQL. Tried various things then admitted defeat and installed new version XAMPP.

I found this migrating MySQL guide and thought it might work but copying over the ib_logfile 0 or ibdata1 caused the start up to fail.

I still have the folder of my database available but these control files will not gel.

Is there any way of rebuilding from just the folder in the mysql\data directory? I expect not.

If not it was a pretty small DB so should take less than 90 mins to rebuild. But, having spent well over 4 hours reinstalling reconfiguring and trying to repair I would just like to see if I can fix the bloomin thing!

Improve this question
2
  • try this steps stackoverflow.com/a/46970116/5193536
    – nbk
    Commented Aug 18, 2019 at 11:49
  • NBK thanks looks like a good steer... but sadly managed to delete the ib_logfile 0 BUT because I am pretty anal about name compliance rebuilt the DB in 38 mins. It occurs to me just now that I should have said that I did not care about data recovery. The DB only has five tables with about 45 columns. Bit of judicious cut and past and voila! I really need to sort out backup I think.
    – BeNice
    Commented Aug 18, 2019 at 16:22
Related questions
4
How to repair a MySQL table without using phpMyAdmin?
6
How to to fix XAMPP after deleting too many MySQL databases?
0
Recover mysql databases from LAMP
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.