MySQL Forums
Forum List  »  Data Recovery

Re: Recover bd from .frm and .ibd
Posted by: Peter Brawley
Date: February 02, 2018 10:58AM

Might work, might not.

InnoDB files can be elsewjere. Is all data in MySQL datadir?

If MySQL had already run against your file copies. you need to delete what's there.

Stop mysql server. Make sure exact same mysql version and my.ini are in place.

Emoty datadir. Copy complete old folder into mysql datadir. delete ib*.log

Restart MySQL, study what mysql error log says

Check/repair all tables, fix errors reported in error log

Options: ReplyQuote

Written By
February 02, 2018 06:42AM
Re: Recover bd from .frm and .ibd
February 02, 2018 10:58AM

Sorry, you can't reply to this topic. It has been closed.

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.