Problem with backup and export database after update mysql ver 5.1 to 5.5

[qtri]

Hi,
After I updated mysql 5.1 to 5.5. I have problem when i backup my site have error:

Not all the data was backed up into /var/lib/psa/dumps/domains/domain.org/databases/xxxxgdb_1 successfully. mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'xxxxxgdb'': Cannot load from mysql.proc. The table is probably corrupted (1548)

And when i use export tool in database it told me errorr :

Unable to export a dump of xxxxxgdb:

• Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead.
• Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead.
• mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'xxxxxgdb'': Cannot load from mysql.proc. The table is probably corrupted (1548)
• Traceback (most recent call last):
• File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module>
• dbbackup.main()
• File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 98, in main
• backup(options, password)
• File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 74, in backup
• raise Exception("program 'mysqldump' finished with non-zero exit code: %d", p2.returncode)
• Exception: ("program 'mysqldump' finished with non-zero exit code: %d", 2)

I follow this link to update mysql http://kb.odin.com/en/125589

What should i do to fix this problem?

Thanks for any help.

 

[IgorG]

Looks like upgrade of MySQL was not completed successfully. I would suggest you create dump of all databases just in case and then complete upgrade with

# mysql_upgrade -uadmin -p` cat /etc/psa/.psa.shadow ` --debug-check --debug-info --verbose