Bug #60161 Getting an error information_schema.routines
Submitted: 17 Feb 2011 14:02 Modified: 17 Feb 2011 17:07
Reporter: guilherme scombatti Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.5 OS:FreeBSD
Assigned to: CPU Architecture:Any
Tags: information_schema, mysql.proc, routines

[17 Feb 2011 14:02] guilherme scombatti 
Description:
Hi,

I'm getting error when i execute this query:

SELECT * FROM information_schema.routines WHERE routine_schema = 'mysql' ORDER BY routine_name;

error:

Query : SELECT * FROM information_schema.routines WHERE routine_schema = 'mysql' ORDER BY  routine_name 

Error Code : 1548
Cannot load from mysql.proc. The table is probably corrupted

MySQL version: 5.5.8
I upgrade 5.1 => 5.5

tks

How to repeat:
just execute: SELECT * FROM information_schema.routines WHERE routine_schema = 'mysql' ORDER BY routine_name;
[17 Feb 2011 14:09] Valeriy Kravchuk 
Had you executed mysql_upgrade after upgrade? See http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html.
[17 Feb 2011 16:32] guilherme scombatti 
Tks man!

it's ok now!