Problem restoring sites with mysql functions and stored procedures

1 post / 0 new
#1 Wed, 04/16/2014 - 04:56
LonDoh

Problem restoring sites with mysql functions and stored procedures

Hi

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.

regards

l.