> 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 _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
