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