Bug 336075 – dev-db/mysql-5.1.50-r1: Add post install note about mysql_upgrade

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description MickKi 2010-09-05 10:30:06 UTC]

Upgrading from dev-db/mysql-5.0.90-r2 to dev-db/mysql-5.1.50-r1 added prefix #mysql50# to two out of 7 databases and the applications that depended on them failed.

An enotice advising of this and a fix would be useful?

This is what I did to remove the prefix:

mysql > ALTER DATABASE `#mysql50#dbname` UPGRADE DATA DIRECTORY NAME;

(Also, FLUSH PRIVILEGES; gave an error.  I had to run mysql_upgrade -u root -p to fix it.)
-- 
Regards,
Mick

[Comment 1 Markos Chandras (RETIRED) 2010-09-05 10:35:56 UTC]

did you run mysql_upgrade when you updated your MYSQL?

[Comment 2 MickKi 2010-09-05 10:48:44 UTC]

No, I didn't know that I had to.
-- 
Regards,
Mick

[Comment 3 Markos Chandras (RETIRED) 2010-09-05 10:52:09 UTC]

Seems like few people knew about that so assigning to maintainer. Maybe he wants to add a post install comment on that

[Comment 4 Robin Johnson 2010-09-06 08:02:16 UTC]

added