28 Aug
2009
28 Aug
'09
1:24 p.m.
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)