So I found a workaround, I had to mysqldump out the tables I wanted and import into an empty mysql8.0 cluster. I still don’t know why we were getting error 197, there’s no clear error logging here to tell me what happened.
Data seems to be intact but the workaround was somewhat difficult. In addition that spawn an additional question.
- I accidentally exported and imported system tables, so in mysql8 the import converted the mysql.users table to MyISAM, but given that its defaultly InnoDB in Mysql8, is there a reason why it converted it? I am guessing its not something you folks have a direct hand in, but figured I’d ask in any case.