I was sure that the mysql 5.5.x upgrade script was supposed to dump and restore tables, but having just upgraded from 5.0.x to 5.5.x I noted a number of tables with errors similar to this when running mysql_upgrade afterwards:
error : Table rebuild required. Please do "ALTER TABLE `sys_users` FORCE" or dump/reload to fix it!
Did that function not get added after all?
EDIT: Odd....mysqlcheck --all-databases gives all the tables a clean bill of health. I don't know what to make of this.
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
These were all Plesk's own tables, which AFAIK are UTF-8.
Should I actually do anything about it, given that mysqlcheck seems to think all is OK?
There are no errors on mysqld restart.
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
Yes, if I recall correctly, they are latin something or other. Or swedish? Something odd, anyway.
Is there something specific I should do about it?
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
Yeah, that would be it alright. Up through MySQL 4.0 the default collation was latin1. In 4.1 it was changed to utf8_general. Load it up in your favorite interface and change it to utf8_general (unless you're using international somewhere, then use utf8_unicode) and then the update should run smoothly. Keep in mind that if you have a lot of odd character combos in your data that they may get mangled.
Showing your age Scott? I always had you pegged as being quite young. Compared to me, anyway.
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
Yes, the muppets was out this summer, yeah yeah ... Scotts not old, no he just saw the Muppets, yeah thats it! In fact, he was one of the youth advisors to the Muppets movie. Why he was so youthful they had to bring him a high chair, yeah, thats the ticket!