AWS re:Postを使用することにより、以下に同意したことになります AWS re:Post 利用規約

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

質問済み 6年前1800ビュー
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

回答済み 5年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ