<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p><br>
</p>
<br>
<div class="moz-cite-prefix">On 2017-12-12 11:18 AM, Andrew
Codrington wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CABx7qni__1D2USNdtMUgDYzRV0HogLu6ugDJigPF7C+cqKj-_w@mail.gmail.com">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">On Mon, Dec 11, 2017 at 6:49 PM,
Stephen Worthington <span dir="ltr"><<a
href="mailto:stephen_agent@jsw.gen.nz" target="_blank"
moz-do-not-send="true">stephen_agent@jsw.gen.nz</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><span
class="">On Mon, 11 Dec 2017 15:23:43 -0600, you wrote:<br>
<br>
>The upgrade process to 16.04 breaks mysql. You'll
need to do a MySQL 5.5<br>
>to 5.6 update first.<br>
>Gerald<br>
<br>
</span>No, it does not break MySQL. MySQL works just fine
as do upgrades<br>
from 5.5 to 5.6. There is one setting in the /etc/mysql
config files<br>
which long ago had its name changed and needs to be
renamed right now<br>
by anyone who has not already done it. It is likely to be
present if<br>
you used Mythbuntu Control Center to set up the database
optimisation<br>
settings.<br>
<br>
So, right now, anyone who is reading this should check all
the files<br>
under /etc/mysql for all lines like this:<br>
<br>
table_cache = 128<br>
and rename that option to:<br>
table_open_cache = 128<br>
</blockquote>
<div><br>
</div>
<div>I ran into that just last week, and that's all it was.<br>
<br>
</div>
<div>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"?<br>
<br>
</div>
</div>
</div>
</div>
</blockquote>
<br>
Upgrades from MySQL 5.5 (Ubuntu 14.04) to MySQL 5.7 (Ubuntu 16.04)
are not supported.
<a class="moz-txt-link-freetext" href="https://askubuntu.com/questions/750498/mysql-5-5-update-to-mysql-5-7">https://askubuntu.com/questions/750498/mysql-5-5-update-to-mysql-5-7</a><br>
<br>
Gerald<br>
<br>
</body>
</html>