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

Mapi33
已提问 5 年前1438 查看次数
1 回答
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

Mapi33
已回答 5 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则