MySQL Forums
Forum List  »  Data Recovery

Re: Databases Recovery from ibdata1 and .frm files
Posted by: Peter Brawley
Date: December 11, 2021 01:12PM

What was the version of the MySQL instance that crashed? Is there a surviving copy of its my.ini? If so, please post it.

There are no backups? Next time you set up a database server, institute regular reliable backups at intervals shorter than the time it takes to collect the amount of data you can afford to lose.

The data folder of the original MySQL installation has been destroyed? If so, next time don't do that. Otherwise please show us the first MySQL error log entries related to the crash.

Pending the above info, one thing you can try is, move ib_log*.* to another location, try starting MySQL, report mysql error log entrees here.

Edit: In the other thread that you've opened re your issues, you partially answer some of these questions. To prevent confusion, let's stay with just this one thread. If I understand you correctly, the original version was 5.5 and the original data folder still exists. If that's so, please do this ...

1. Post the contents of my.ini. Save a copy of it.

2. Open the mysql error log (usually named <machine-name>.err) in a text editor and post here copies of the first error message related to the crash.

3. Move ib_log*.* to a safe location, edit my.ini to point MySQL to this original data folder, start MySQL in a console window with the command ...

mysqld --defaults_file="path-to-original-my.ini" --console

and post here the error messages you see.

Edited 1 time(s). Last edit at 12/11/2021 01:50PM by Peter Brawley.

Options: ReplyQuote

Written By
Re: Databases Recovery from ibdata1 and .frm files
December 11, 2021 01:12PM

Sorry, only registered users may post in this forum.

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.