[mythtv-users] Upgrade?

[Jay Foster]

On 12/11/2017 3:49 PM, Stephen Worthington wrote:
> 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.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
My "/etc/mysql/my.cnf" file has "#table_cache = 64" in it.  Since it is 
commented out, I am guessing it makes no difference if it is or is not 
table_open_cache.
Jay