[mythtv-users] Upgrade?

Stephen Worthington stephen_agent at jsw.gen.nz
Mon Dec 11 23:49:05 UTC 2017


On Mon, 11 Dec 2017 15:23:43 -0600, you wrote:

>The upgrade process to 16.04 breaks mysql. You'll need to do a MySQL 5.5 
>to 5.6 update first.
>
>Gerald

No, it does not break MySQL.  MySQL works just fine as do upgrades
from 5.5 to 5.6.  There is one setting in the /etc/mysql config files
which long ago had its name changed and needs to be renamed right now
by anyone who has not already done it.  It is likely to be present if
you used Mythbuntu Control Center to set up the database optimisation
settings.

So, right now, anyone who is reading this should check all the files
under /etc/mysql for all lines like this:

table_cache = 128

and rename that option to:

table_open_cache = 128

The table_cache name for that option was deprecated many versions of
MySQL ago, but Mythbuntu Control Center was never fixed.  In MySQL
5.6, the old deprecated name has finally been removed and MySQL will
fail to start up until the name is fixed.  This problem has been
mentioned previously many times here on this mailing list and
elsewhere.

Mythbuntu Control Center itself is now no longer supported, so this
problem will never be fixed at that end.


More information about the mythtv-users mailing list