store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Mon Nov 24, 2014 6:28 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 12 posts ] 
Author Message
 Post subject: mysql upgrade script?
Unread postPosted: Fri Jan 20, 2012 9:20 pm 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Thu Dec 09, 2004 11:19 am
Posts: 2106
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:
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>


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Sun Jan 22, 2012 12:40 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7957
Location: earth
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.


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Sun Jan 22, 2012 2:52 pm 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Thu Dec 09, 2004 11:19 am
Posts: 2106
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>


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Tue Jan 24, 2012 12:26 pm 
Offline
Forum Regular
Forum Regular

Joined: Mon Apr 10, 2006 12:55 pm
Posts: 673
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


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Tue Jan 24, 2012 4:19 pm 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Thu Dec 09, 2004 11:19 am
Posts: 2106
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>


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Tue Jan 24, 2012 5:34 pm 
Offline
Forum Regular
Forum Regular

Joined: Mon Apr 10, 2006 12:55 pm
Posts: 673
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


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Wed Jan 25, 2012 8:23 am 
Offline
Forum Regular
Forum Regular

Joined: Tue Jul 15, 2008 2:38 pm
Posts: 778
Location: Sweden
faris wrote:
Or swedish? Something odd, anyway.


ThereĀ“s nothing odd with swedish! :wink:


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Wed Jan 25, 2012 10:22 am 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7957
Location: earth
bork! bork! bork!


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Wed Jan 25, 2012 10:49 am 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Thu Dec 09, 2004 11:19 am
Posts: 2106
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>


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Wed Jan 25, 2012 6:04 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7957
Location: earth
The Muppets was out this summer!


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Wed Jan 25, 2012 7:03 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
User avatar

Joined: Thu Feb 07, 2008 7:49 pm
Posts: 3670
Location: Chantilly, VA
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!

_________________
Michael Shinn
Atomicorp - Security For Everyone

Co-Author of Troubleshooting Linux Firewalls.


Top
 Profile  
 
 Post subject: Re: mysql upgrade script?
Unread postPosted: Thu Jan 26, 2012 5:02 pm 
Offline
Forum Regular
Forum Regular

Joined: Tue Jul 15, 2008 2:38 pm
Posts: 778
Location: Sweden
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...


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group