[mythtv-users] Upgrade?

[Andrew Codrington]

On Mon, Dec 11, 2017 at 6:49 PM, Stephen Worthington <
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"?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20171212/1e0285b7/attachment.html>