Posts

Showing posts from April 18, 2019

MySQL upgrade from 5.6 to 8.0

Image
0 When trying to start MySQL 8.0 it complained about partially upgraded DD. Furthermore, it complained about not being to open a table S/AD.ibd which no longer exists there because we moved it to S/AD.ibd. We reverted back to MySQL 5.6 and it seems to be running fine now. It looks like it failed during converting the .frm files into the information_schema, and I suppose this is why we were able to revert back to 5.6. My questions: 1) Does anyone have any idea what this could be? 2) Are there MySQL diagnostic tools I can run against our 5.6 instance to see if there is inconsistent state stored about our AD.ibd table? Here is the full log if it's of interest: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the cra