I am new to MySQL administration, and this week a customer came to me with a problem. They created an application with Wamp in a Windows Server environment.
For some reason when listing the tables in the MySQL Workbench, an error pops up saying could not be fetched
.
And in the output window, the following error is thrown:
They also reported that a stored procedure has disappeared, and when trying to compile it again in MySQL, another error is generated:
ERROR 1031 (HY000): Table storage engine for 'proc' doesn't have this option
Some tables were using the MyISAM engine, so I changed it and now all are as INNODB, and the ROW FORMAT parameters are like Do not Use.
Other information that may be important, this base was developed in a version 5.1, and this base with problems is in version 5.7.14.