<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<div class="moz-cite-prefix">On 7/23/20 11:42 PM, Stephen
Worthington wrote:<br>
</div>
<blockquote type="cite"
cite="mid:aplkhfpvt7d7ekvoj7sr648dasvbt215rs@4ax.com">
<pre class="moz-quote-pre" wrap="">On Thu, 23 Jul 2020 13:27:50 -0700, you wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">Is there any "preferred" or most stable Ubuntu version for the latest
MythTV? It seems like many people are running 18.04, but there are 19.10
and 20.04 versions as well. Other things being equal I would go to the
latest, but in the past I have seen people having problems running Myth on
the latest releases.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
There is a problem with the latest MariaDB versions which you get in
Ubuntu 20.04. So if you want to use MariaDB, stick with 18.04 for the
moment. If you are using lirc, the packages are broken on 18.04 and
20.04, but I have fix scripts on my web server for both now. I do not
have scripts for the non-LTS Ubuntus. You can not do an upgrade from
LTS to 20.04 yet - the 20.4.1 release which allows that is still a few
days away.
</pre>
</blockquote>
<p>Stephen,</p>
<p>I'm glad you posted these comments. I've been wondering about the
Ubuntu 20.04 issue with MariaDB. I'm following the bug report (<a
href="https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1877504">https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1877504</a>)
but no update lately.</p>
<p>From my experimenting I believe that if I have to move to Ubuntu
20.04 before there is a fix, my only choice would be to back
everything up create a new Ubuntu 20.04 system and NOT install
MariDB before I install Mythtv v31 and proceed with MySQL 8. I
have been able to restore a daily backup from MariaDB to a new
MySQL system using:</p>
<p> </p>
<p class="western" style="margin-left: 0.5in; margin-bottom: 0in;
line-height: 100%">
<font face="Courier, serif"><font style="font-size: 10pt" size="2">/usr/share/mythtv/mythconverg_restore.pl
--drop_database --create_database --filename /full path to
directory/mythconverg-1214-20080626150513.sql.gz</font></font></p>
<p class="western" style="margin-left: 0.5in; margin-bottom: 0in;
line-height: 100%"><font face="Courier, serif"><font
style="font-size: 10pt" size="2"><br>
</font></font></p>
<p>
<style type="text/css">
p { margin-bottom: 0.1in; direction: ltr; color: #000000; line-height: 115%; text-align: left; orphans: 2; widows: 2 }
p.western { font-family: "Cambria", serif; font-size: 12pt; so-language: en-US }
p.cjk { font-family: "ＭＳ 明朝"; font-size: 12pt; so-language: en-US }
p.ctl { font-family: ; font-size: 12pt; so-language: ar-SA }
a:link { color: #0000ff }</style></p>
</body>
</html>