Problem restoring sites with mysql functions and stored procedures


I’ve had a number of fails when restoring sites that have MYSql stored procdures and functions

typically this is the error:

Re-loading MySQL database site_database …
Creating MySQL database site_database ..
.. done

… load failed!

ERROR 1548 (HY000) at line 4551: Cannot load from mysql.proc. The table is probably corrupted

that mysql.proc table isnt corrupted and is empty.
incoming db tables are verified as ok
I dont think there are errors in the sp’s and functions, but they arent used in this iteration of sites, and its a while since I wrote them and I forget!, and no time to check now - so in truth I’m not 100% on that.

I mention this as a kind of FYI only - since I already got round it by deleting the sp’s and recreating afterwards.