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

Fri Aug 28 11:09:08 UTC 2009
Alexander Dalloz <ad+lists at uni-x.org>

> 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.

Best regards

Alexander