[CentOS] mysql-server-5.0.82sp1-1.el4_8 upgrade
Alexander Dalloz
ad+lists at uni-x.org
Fri Aug 28 11:09:08 UTC 2009
> 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
More information about the CentOS
mailing list