<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/25/20 11:09 AM, DryHeat122 wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAM=qwAHEmX-F5mhbsg-ka10VQZ2SJpTbOBJggw6q6f8Byo65Fw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">I am replacing my Ubuntu 16.04 setup with a clean
install of Myth on a clean install of Utuntu 20.04. I have the
old mythconverg backed up and am getting ready to restore. The
wiki <a href="https://www.mythtv.org/wiki/Backend_migration"
moz-do-not-send="true">backend migration page</a> says
"Depending on how your distribution initialises the database
upon installation of the backend, you may need to use the
procedure for <a
href="https://www.mythtv.org/wiki/Database_Backup_and_Restore#Replacing_an_existing_database"
title="Database Backup and Restore"
style="font-size:14px;line-height:22.4px"
moz-do-not-send="true">replacing the database by the backup</a>."
<div><br>
</div>
<div>The referenced page says: "
If you are replacing an existing database with a known-good
backup by using a full restore--for example, because your
database has been corrupted or a database schema upgrade
failed or you're replacing a package-provided database with
your "old" database after re-installing your distro--you will
need to drop the existing database. "</div>
<div><br>
</div>
<div>I don't know how 20.04 initializes the DB. I am not
replacing the DB because of corruption or failed upgrade. Do
I run <a href="http://mythconverg_restore.pl"
moz-do-not-send="true">mythconverg_restore.pl</a> with
defaults or include the drop and create arguments? Also to be
clear, I should restore the DB after installing myth but
before running setup, right? <br>
</div>
</div>
</blockquote>
<p>The last time I created fresh and wanted to restore from a good
backup I had just run on the old system, I did the following
command:</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>
<font style="font-size: 10pt" size="2">Jim A</font>
<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: "MS 明朝"; 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>