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

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