[mythtv-users] Upgrade?

[Gerald Brandt]

On 2017-12-12 11:18 AM, Andrew Codrington wrote:
> On Mon, Dec 11, 2017 at 6:49 PM, Stephen Worthington 
> <stephen_agent at jsw.gen.nz <mailto:stephen_agent at jsw.gen.nz>> 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
>
>
> I ran into that just last week, and that's all it was.
>
> As this is a teachable moment, can anyone share a command line to 
> search the filesystem (or a recursive folder search) for files 
> containing a specific text string like "table_cache"?
>

Upgrades from MySQL 5.5 (Ubuntu 14.04) to MySQL 5.7 (Ubuntu 16.04) are 
not supported. 
https://askubuntu.com/questions/750498/mysql-5-5-update-to-mysql-5-7

Gerald

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20171212/e2e3d560/attachment.html>