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)
signature.asc
Description: OpenPGP digital signature
_______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
