Hi, There has been update to mysql within the centosplus repository on 26th August. Please be aware, that you might need to upgrade tables after the server upgrade.
1) run CHECK TABLE .... 2) if the response is 'Table upgrade required. Please do "REPAIR TABLE `tablename`" to fix it!' 3) do run :o) REPAIR TABLE 4) good point is again CHECK TABLE 4) good point is OPTIMIZE TABLE
Regards, David Hrbáč
Hi, There has been update to mysql within the centosplus repository on 26th August. Please be aware, that you might need to upgrade tables after the server upgrade.
- run CHECK TABLE ....
- if the response is 'Table upgrade required. Please do "REPAIR TABLE
`tablename`" to fix it!' 3) do run :o) REPAIR TABLE 4) good point is again CHECK TABLE 4) good point is OPTIMIZE TABLE
Regards, David Hrbáč
Good hint.
Please see as well "man 1 mysql_upgrade". This makes this process more handy if you have lots of databases and tables.
The binary comes with the mysql-server package and is located at /usr/bin/mysql_upgrade.
Best regards
Alexander
Alexander Dalloz wrote:
Hi, There has been update to mysql within the centosplus repository on 26th August. Please be aware, that you might need to upgrade tables after the server upgrade.
- run CHECK TABLE ....
- if the response is 'Table upgrade required. Please do "REPAIR TABLE
`tablename`" to fix it!' 3) do run :o) REPAIR TABLE 4) good point is again CHECK TABLE 4) good point is OPTIMIZE TABLE
Regards, David Hrbáč
Good hint.
Please see as well "man 1 mysql_upgrade". This makes this process more handy if you have lots of databases and tables.
The binary comes with the mysql-server package and is located at /usr/bin/mysql_upgrade.
Or mysqlcheck (see man mysqlcheck)
However, if you were already using the latest centosplus mysql before the update (5.0.68) then you shouldn't need to upgrade the tables for that update. (5.0.68 -> 5.0.82sp1)
-
Alexander Dalloz -
David Hrbáč -
Johnny Hughes