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년 전1433회 조회
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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠