“is a new issue with the latest versin of SQLyog. i.e. This was not a problem with an earlier version of SQLyog”.
We hear that often – also when it is not the case. But how can you tell? Do you have both versions installed? It is also very well possible that something happened with the server at about the same time as you upgraded. I can export successfully here with 11.01. And expand the node in the Object Browser as well.
Please tell: what happens if you execute the SQL statement:
“SELECT `SPECIFIC_NAME` FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'test' AND ROUTINE_TYPE = 'PROCEDURE';”
(replace 'test' with your actual database name).
This is the query that is executed when you expand the node and if SQLyog returns an error on this statement, any client would do.
Information_schema is a memory database. Have you tried to restart MySQL? Also try these statements http://dev.mysql.com/doc/refman/5.5/en/table-maintenance-sql.html agaisnt the 'proc' table in the 'mysql' database (you may do from SQLyog 'tools' menu).
Also simply try the statement “SELECT * FROM mysql.proc”