[CentOS] mysql-server-5.0.82sp1-1.el4_8 upgrade

Johnny Hughes johnny at centos.org
Fri Aug 28 11:24:55 UTC 2009


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.
>>
>> 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áč
> 
> 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)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 251 bytes
Desc: OpenPGP digital signature
URL: <http://lists.centos.org/pipermail/centos/attachments/20090828/80ba4d88/attachment.sig>


More information about the CentOS mailing list