Ao usar o AWS re:Post, você concorda com os AWS re:Post Termos de uso

Migration error: "Schema inconsistencies resulting from file removal..."

0

I can't migrate from mySQL 5.X.X to 8.X.X.
The PrePatchCompatibility.log shows the following:

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
scraper@002dapi.requests_pages - present in INFORMATION_SCHEMA's INNODB_SYS_TABLES table but missing from TABLES table

However when I look at the table information_schema.TABLES I see:

TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ...

def | scraper-api | requests_pages | BASE TABLE | ...

The difference being in the dash of "scraper-api", but other tables with a dash in the name are well recognized.
How can I fix it?

Edited by: Mapi33 on May 23, 2019 7:32 AM

Edited by: Mapi33 on May 23, 2019 7:33 AM

feita há 6 anos1,8 mil visualizações
1 Resposta
0

I've resolved it by changing the DB name and avoid dash character in it.

Note that it was also advised to convert some columns to utf8md4.
In fact it's not just an advice as the upgrade will not work without doing so

respondido há 5 anos

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