Page 1 of 1

mysql upgrade script?

Posted: Fri Jan 20, 2012 9:20 pm
by faris
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:

Code: Select all

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.

Re: mysql upgrade script?

Posted: Sun Jan 22, 2012 12:40 pm
by scott
Sometimes due to the nature of the existing data in the tables, conflicts can only be resolved manually. Usually this happens with UTF-8 conversions.

Re: mysql upgrade script?

Posted: Sun Jan 22, 2012 2:52 pm
by faris
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.

Re: mysql upgrade script?

Posted: Tue Jan 24, 2012 12:26 pm
by Highland
Is it an older Plesk install? If so, it could have a table that was latin that's not been converted to UTF-8

Re: mysql upgrade script?

Posted: Tue Jan 24, 2012 4:19 pm
by faris
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?

Re: mysql upgrade script?

Posted: Tue Jan 24, 2012 5:34 pm
by Highland
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.

You can also do the dump and restore method, although it takes a lot more work.
http://en.gentoo-wiki.com/wiki/Convert_ ... 8_in_MySQL

Re: mysql upgrade script?

Posted: Wed Jan 25, 2012 8:23 am
by biggles
faris wrote:Or swedish? Something odd, anyway.
ThereĀ“s nothing odd with swedish! :wink:

Re: mysql upgrade script?

Posted: Wed Jan 25, 2012 10:22 am
by scott
bork! bork! bork!

Re: mysql upgrade script?

Posted: Wed Jan 25, 2012 10:49 am
by faris
Showing your age Scott? I always had you pegged as being quite young. Compared to me, anyway.

Re: mysql upgrade script?

Posted: Wed Jan 25, 2012 6:04 pm
by scott
The Muppets was out this summer!

Re: mysql upgrade script?

Posted: Wed Jan 25, 2012 7:03 pm
by mikeshinn
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!

Re: mysql upgrade script?

Posted: Thu Jan 26, 2012 5:02 pm
by biggles
faris wrote:Showing your age Scott? I always had you pegged as being quite young. Compared to me, anyway.
Young, compared to what? Even I saw the Swedish Chef and I'm was born in the seventies...