Table Problems on legacy databases

[Vito Cavallo]

Hello,
I inherited an old CentOS 7 linux server running mysql 5.744
MySQL is running and there are approximately 15 databases.
I am migrating to Rocky 9 running MySQL 8.4.32
Half of the databases work. The other half wont work.
No idea what the previous users did when using and uploading data.

The database folders have idb and frm files. Anywhere from 100 MB to 3 GB folder size, so some data is there.

In MySQL Workbench, I can see databases and tables, but getting the error
"Tables could not be fetched". Everything looks like the good databases.
The tables are shown as folders, inside folders i see Columns and Index and Foreign Keys folders.

Using mysql app on the server, I can list databases and tables.
repair tables prints "Table xxx doesn't exist"

I cant repair, I cant dump, I cant drop.

mysqldump of tables is error 1146: doesn't exist when using LOCK TABLES
mysqlcheck of all database error 2013 lost connection to mysql server when executing 'CHECK TABLE'
I modifed the my.cnf file to allow interactive_timeout - 57600 and wait_timeout

Folders owned by mysql and attributes were 755 and 770.

any ideas how to repair or recreate the bad databases ?


Thank you.