[MySQL] – Old DB restored on MySQL – Error loading schema content (Error Code: 1548 Cannot load from mysql.proc. The table is probably corrupted)

Just a quick post as I have had this problem and I couldn’t find a solution on Google.
I tried to restore an old MySQL database on my Windows 2008 R2 using Workbench 6.0.

The restore was successful, I could query the db via PHP but trying to open the schema via Workbench I would now get an error:
Error loading schema content
Error Code: 1548 Cannot load from mysql.proc. The table is probably corrupted

The fix is easy: go to the MySQL bin folder and run mysql_upgrade (-p to make it ask for the root password).

HTH,
Roberto.

Advertisements