D dreamfox Verified User Joined Mar 13, 2006 Messages 50 Aug 18, 2010 #1 Hello, Just a simple question. My sysadmin is telling me I can not upgrade from mysql 5.0.x to mysql 5.1.x He says that all databases broken then. Is that true?
Hello, Just a simple question. My sysadmin is telling me I can not upgrade from mysql 5.0.x to mysql 5.1.x He says that all databases broken then. Is that true?
D daveyw Verified User Joined Jan 5, 2008 Messages 668 Location /dev/null Aug 19, 2010 #2 Normally (what I can remember) then you upgrade from 4 to 5.0.x to 5.1.x it will upgrade the tables for 5.1.x. When I was upgrading from 4 to 5 it upgraded all tables. Please don't forget also that PHP must be rebuilded after updating MySQL.
Normally (what I can remember) then you upgrade from 4 to 5.0.x to 5.1.x it will upgrade the tables for 5.1.x. When I was upgrading from 4 to 5 it upgraded all tables. Please don't forget also that PHP must be rebuilded after updating MySQL.
J jocurileus New member Joined Aug 15, 2010 Messages 1 Aug 20, 2010 #3 You can try to test for incompatibilities: Code: mysqlcheck –uroot –p –A –check-upgrade -> shows incompatibilities and run Code: mysql_upgrade –uroot –p after upgrade. He can backup all the databases upgrade and see if there are any problems or he can use a sandbox to test the upgrade.
You can try to test for incompatibilities: Code: mysqlcheck –uroot –p –A –check-upgrade -> shows incompatibilities and run Code: mysql_upgrade –uroot –p after upgrade. He can backup all the databases upgrade and see if there are any problems or he can use a sandbox to test the upgrade.
