On Saturday 05 September 2009 08:25:22 am Per Jessen wrote:
Per Jessen wrote:
I'm thinking of upgrading a production database this weekend as the running version 5.0.51a keeps crashing, see bug 516339. Would anyone care to make a recommendation as to which version to upgrade to? 5.0.x , 5.1.x ? Keep in mind that this is 24h production, I would rather not opt for the bleeding edge stuff.
I ended up choosing 5.1.36, and am now reloading the tables. DUring the upgrade I got the following weird messages:
Failed to ALTER DATABASE `#mysql50#.protected` UPGRADE DATA DIRECTORY NAME Error: Table 'mysql.event' doesn't exist Failed to ALTER DATABASE `#mysql50#.tmp` UPGRADE DATA DIRECTORY NAME Error: Table 'mysql.event' doesn't exist
I've now also got two databases named '.protected' and '.tmp'. Does anyone what might have happened?
thanks Per
Per, I'm running the following mysql versions on these different servers without any problem. The only annoyance is the latest rpms for mysql don't restart mysql after the upgrade, but all databases are working without error. 19:15 bonza~> rpm -q mysql mysql-5.1.36-41.1 20:46 archangel:~> pmq mysql mysql 5.1.37-1 [17:32 nirvana:/srv/www/avantfax/includes] # rpm -q mysql mysql-5.1.36-41.1 [18:06 nemesis:/etc/ppp] # rpm -q mysql mysql-5.1.36-39.1 -- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org