mysql upgrade script?

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

mysql upgrade script?

Unread post 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.
--------------------------------
<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>
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: mysql upgrade script?

Unread post 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.
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: mysql upgrade script?

Unread post 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.
--------------------------------
<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>
Highland
Forum Regular
Forum Regular
Posts: 674
Joined: Mon Apr 10, 2006 12:55 pm

Re: mysql upgrade script?

Unread post 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
"Its not a mac. I run linux... I'm actually cool." - scott
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: mysql upgrade script?

Unread post 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?
--------------------------------
<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>
Highland
Forum Regular
Forum Regular
Posts: 674
Joined: Mon Apr 10, 2006 12:55 pm

Re: mysql upgrade script?

Unread post 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
"Its not a mac. I run linux... I'm actually cool." - scott
biggles
Forum Regular
Forum Regular
Posts: 806
Joined: Tue Jul 15, 2008 2:38 pm
Location: Sweden
Contact:

Re: mysql upgrade script?

Unread post by biggles »

faris wrote:Or swedish? Something odd, anyway.
There´s nothing odd with swedish! :wink:
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: mysql upgrade script?

Unread post by scott »

bork! bork! bork!
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: mysql upgrade script?

Unread post by faris »

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>
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Re: mysql upgrade script?

Unread post by scott »

The Muppets was out this summer!
User avatar
mikeshinn
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 4149
Joined: Thu Feb 07, 2008 7:49 pm
Location: Chantilly, VA

Re: mysql upgrade script?

Unread post 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!
biggles
Forum Regular
Forum Regular
Posts: 806
Joined: Tue Jul 15, 2008 2:38 pm
Location: Sweden
Contact:

Re: mysql upgrade script?

Unread post 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...
Post Reply