Re: mysql-server-5.0.82sp1-1.el4_8 upgrade

["Alexander Dalloz" <ad+lists@xxxxxxxxx>]

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


_______________________________________________CentOS mailing listCentOS@xxxxxxxxxxxxxx://lists.centos.org/mailman/listinfo/centos