Unable to upgrade MySQL from 5.7.44 to 8.x

0

While trying to upgrade my MySQL from 5.7.44 to 8.x, I am getting the following error:

  1. Schema inconsistencies resulting from file removal or corruption: Following tables show signs that either table datadir directory or frm file was removed/corrupted. Please check server logs, examine datadir to detect the issue and fix it before upgrade mytable - present in INFORMATION_SCHEMA's INNODB_SYS_TABLES table but missing from TABLES table

I tried to use some solutions mentioned on repost and stackoverflow like: https://repost.aws/questions/QUPC7D-_ZuTgCZSLALluxW9g/need-help-in-upgrading-the-aurora-mysql-5-7-to-mysql-8-urgent https://repost.aws/questions/QUNKcZd0MBSPmyPcCJanyKSQ/aurora-upgrade-2-to-3-mysql-5-7-to-8-0-schemainconsistencycheck

However, when I run the suggested query to find corrupted tables, I cannot find any table with the pattern '%#sql%' or '%#%'

select * from information_schema.innodb_sys_tables where name like '%#%';

Does anyone have any other possible solution?

feita há 7 meses312 visualizações
1 Resposta
0

Hi,

You may want to read and follow the guidance of https://planetscale.com/blog/upgrading-to-mysql-8

Best,

Didier

profile pictureAWS
ESPECIALISTA
respondido há 7 meses
  • Hi, I read the recommendations, however I did not find info related to schema inconsistencies from file removal or corruption in your text. Thanks anyway

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas