Error 1547

Hi All,
I have taken a back-up and then restored my data, but my stored procedure table is not reflecting and when i tried to run the query it says "SQL error (1547): Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted."So would like to know what would be the probable cause and how to solve/rectify it.
Thanks

I guess you did a full backup, including the "mysql" database, then you updated the server to a new release and imported that dump?

You should never do that with the "mysql" database when updating the server, as the structure changes in nearly each MySQL release. Now you have the old structure on a new server. You will need to restore the original mysql database from the new installation and then carefully insert rows into the tables user, host, db, tables_priv, columns_priv and procs_priv. Nothing else, no structure. And be careful.

Yes Anse, I have done the full backup, now I have taken only the concerned tables for backup, my problem is even after restoring it on the same version when i run my stored procedure query it again says the same error 1547. Do i need to reinstall sql again and do this exercise?

DAMN NICE DUDE

What is nice, dude? Sounds like a spammer. :)

I don't know what versions you have exactly now, so I can't give you an exact advice. I would guess you should go and restore the mysql database structure for your current server version.

Ok. Now i am using 5.5.8

@jaeger45: Thanks for this ostentatious ACT... DUDE!!!!