[CentOS] mysql-server-5.0.82sp1-1.el4_8 upgrade
Johnny Hughes
johnny at centos.orgFri Aug 28 11:24:55 UTC 2009
- Previous message: [CentOS] mysql-server-5.0.82sp1-1.el4_8 upgrade
- Next message: [CentOS] [off-topic] Question about csh.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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-0001.sig>
- Previous message: [CentOS] mysql-server-5.0.82sp1-1.el4_8 upgrade
- Next message: [CentOS] [off-topic] Question about csh.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the CentOS mailing list