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.