Re: Mysql server 5.7 recovery
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.
Subject
Written By
Posted
Re: Mysql server 5.7 recovery
June 20, 2021 11:47PM
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.