MySQL Forums
Forum List  »  InnoDB

Re: Error message on OS freebsd
Posted by: Peter Brawley
Date: August 09, 2020 12:41PM

MySQL 5.7 & 8 can't do without sys and mysql DBs.

Do you have a logical backup, eg by mysqldump, from mysql 5.7? That should get you back to a working 5.7 system.

I've seen this suggestion ...

Navigate to the datadir

Delete ib_logfile*

Move ibdata1 to a safe place

Restart mysql

If that fails, restore ibdata1 and set innodb_force_recovery=1 and try again, repeat up to 6 if failure recurs

The only reliable way I know to move from 5.7 to 8.0 is to backup 5.7, install 8.0 as a new installation, then import the 5.7 data files. If Freebsd tried to upgrade in place without warning you of the need for a backup, it did you a disservice.

Options: ReplyQuote


Subject
Views
Written By
Posted
904
August 08, 2020 07:17PM
449
August 08, 2020 07:22PM
439
August 08, 2020 07:25PM
458
August 08, 2020 09:53PM
468
August 08, 2020 10:05PM
507
August 08, 2020 10:25PM
1054
August 09, 2020 11:19AM
Re: Error message on OS freebsd
606
August 09, 2020 12:41PM
532
August 09, 2020 06:40PM
440
August 09, 2020 08:36PM
510
August 12, 2020 08:48PM
479
August 13, 2020 08:26AM
477
August 13, 2020 09:48AM


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.