[mythtv-users] MySQL 5.1 to 5.5 upgrade on Gentoo

[Tom Dexter]

On Tue, Aug 19, 2014 at 8:01 PM, Karl Newman <newmank1 at asme.org> wrote:

> No, I didn't have to recompile mythtv after emerge-ing mysql 5.5.
>

Thanks!  Good to know.

> Yeah, I had a backup but I didn't do any of that. I just ran (as root)
> "mysql_upgrade -u root -p"   I happened to do it while mysql was running, it
> didn't give me any warnings and it completed fine. Make sure you specify "-u
> root -p" (even though the help says it defaults to user root) otherwise it
> will silently fail.

Yea, you definitely need to do that as root.  Still up in the air on
doing the restore etc.  I've never needed it with previous upgrades.
I have a feeling that, especially when just MyISAM tables are
involved, it's most likely overkill.

> I think mysql_upgrade mostly just adds some new system tables. It ran pretty
> quick on my system (a few seconds), which implies to me it wasn't doing a
> lot of data manipulation.

Yea...what I was unclear on is...assuming I'm going to restore the
database, if it's best to have all those system tables updated before
restoring.  It seems like that'd be the case.

>
>>
>> Just wanted to see it I was on the right track there.
>
>
> Caveat: When you do your etc-update or dispatch-conf to merge your existing
> mysql.cnf with the new one, make sure you don't include the
> default_character_set line in the mysqld section. I made that mistake and it
> caused a 15 minute stall in booting my system before start-stop-daemon would
> time out on mysql. Also check your /var/log/mysql/mysqld.err for errors or
> warnings.

Thanks for the heads up, and all the advice!

Tom