MySQL Forums
Forum List  »  Newbie

Re: Mysql server 5.7 recovery
Posted by: Barry Galbraith
Date: June 20, 2021 11:47PM

Were you using innoDB engine to store you data?
Yes?
Were you using "file per table" option?
No?
The data and indexes for your table is in ibdata1 file in the \data folder. That's the folder containing the folder(s) for each database.

ib_logfile0 and ib_logfile1 contain the rollback info.
If you want to use your old files then the setting of innodb_log_file_size in my.ini must be the same as it was in the old server. If it's different, don't use the ib_logfile0 and ib_logfile1. They will be created on startup of MySQL server if they aren't present.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Mysql server 5.7 recovery
June 20, 2021 11:47PM


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.