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

[Karl Newman]

On Tue, Aug 19, 2014 at 3:53 PM, Tom Dexter <digitalaudiorock at gmail.com>
wrote:

> If anyone is running MythTV on Gentoo, I have a few questions
> regarding the MySQL 5.1 to 5.5 upgrade:
>
> First of all, does the MySQL upgrade end up forcing a re-compile of
> MythTV, either directly or via @preserved_rebuild?  I'd like to know
> if I'm going to have to deal with that one.
>
> No, I didn't have to recompile mythtv after emerge-ing mysql 5.5.


> Before I do anything I plan on making sure that no tables need repair
> etc.  Also, to play it safe I plan to sql dump, drop, re-create and
> restore the mythconverg database, but looking at the upgrade
> instructions I'm a little confused by the exact order of steps.
>
> 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.


> Since I plan on re-creating and restoring the database, I was thinking
> that I should just backup and drop the database before even upgrading.
> After that, I wasn't clear as to whether I should be running the
> mysql_upgrade before re-creating and restoring mythconverg.  I figured
> that would be best because mysql_upgrade will be making changes to the
> mysql database schema etc.
>
> 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.


> 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.

Sincerely,

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140819/a2e435a5/attachment.html>