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

Question

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 · Answer

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

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

TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ...

相關內容