When creating a stored procedure- #1548 - Cannot load from mysql.proc

[cybersle]

I am having an issue creating stored procedures. I keep getting:
#1548 - Cannot load from mysql.proc. The table is probably corrupted

Which according to everything I can find on google this happens due to schema changes required for different MySQL server versions. The simple fix to this problem is to run the mysql_upgrade command from the command line. Which obviously I cannot do. I've tried running a fix on the table and updating the database via the GUI provided.

I also tried utilizing the Create routine tab and entering the items manually without using the deliminator but I still get the same error.

I also tried creating a new database with very little in it and creating a stored procedure there. Still receive the same error.

PLEASE HELP!

 

[Skizzerz]

Please try again, I've repaired the mysql.proc table (so if it was indeed corrupted, that would have fixed it).

 

[cybersle]

Still having the same issue, I can't even access the table:



Can you just delete my entire library and I'll start from scratch?

When I try deleting and recreating my db the information schema remains unchanged. I don't know what happened but at this point it would be easier to start fresh.

Thank you!

 

[cybersle]

Never mind, I'll just direct query what I can, since it has to be done today.

 

[bplanx12]

I have the same issue... could you help me as soon as possible?
Thanks

 

[bplanx12]

I really need to solve this issue. Could you help me please??