[CentOS] mysql-server-5.0.82sp1-1.el4_8 upgrade
johnny at centos.org
Fri Aug 28 11:24:55 UTC 2009
Alexander Dalloz wrote:
>> 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
>> 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
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)
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 251 bytes
Desc: OpenPGP digital signature
More information about the CentOS