<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Hmm, OK, so I copied all of the backed-up files from <span class="gmail-im">          /backupdisk/var/lib/mysql/mythconverg to the active <span class="gmail-im">/var/lib/mysql/mythconverg.  I gave the mythtv user access as suggested by Ian, and I can log in as the mythtv user and access the mythconverg database.  However, I now have an odd result.  I can show the databases:</span></span></div><div><span class="gmail-im"><span class="gmail-im"><br></span></span></div><div><span style="font-family:monospace,monospace"><span class="gmail-im"><span class="gmail-im">MariaDB [(none)]> show databases;<br>+--------------------+<br>| Database           |<br>+--------------------+<br>| information_schema |<br>| mythconverg        |<br>+--------------------+<br></span></span></span></div><div><span class="gmail-im"><span class="gmail-im"><br></span></span></div><div><span class="gmail-im"><span class="gmail-im">and I can show the tables in mythconverg:</span></span></div><div><span class="gmail-im"><span class="gmail-im"><br></span></span></div><div><span style="font-family:monospace,monospace"><span class="gmail-im"><span class="gmail-im">MariaDB [(none)]> use mythconverg;<br>Reading table information for completion of table and column names<br>You can turn off this feature to get a quicker startup with -A<br><br>Database changed<br>MariaDB [mythconverg]> show tables;<br>+--------------------------------+<br>| Tables_in_mythconverg          |<br>+--------------------------------+<br>| archiveitems                   |<br>| bdbookmark                     |<br>| callsignnetworkmap             |<br>| capturecard                    |<br>| cardinput                      |<br>| channel                        |<br>| channelgroup                   |<br></span></span></span></div><div><span class="gmail-im"><span class="gmail-im"><br></span></span></div><div><span class="gmail-im"><span class="gmail-im">But if I try to access one of the tables, I get an error saying that it doesn't exist:</span></span></div><div><span class="gmail-im"><span class="gmail-im"></span></span></div><div><span class="gmail-im"><span class="gmail-im"><br><span style="font-family:monospace,monospace">MariaDB [mythconverg]> describe scannerfile;<br>ERROR 1146 (42S02): Table 'mythconverg.scannerfile' doesn't exist<br>MariaDB [mythconverg]> select * from settings;<br>ERROR 1146 (42S02): Table 'mythconverg.settings' doesn't exist<br></span></span></span></div><div><span style="font-family:monospace,monospace"><span class="gmail-im"><span class="gmail-im"><br></span></span></span></div><div><span class="gmail-im"><span class="gmail-im">Any thoughts?  I've confirmed that both the settings files (settings.frm, settings.MYD and settings.MYI) as well as the same scannerfile files are in /var/lib/mysql/mythconverg.</span></span></div><div><span class="gmail-im"><span class="gmail-im"><br></span></span></div><div><span class="gmail-im"><span class="gmail-im">I did shut down mysql before moving the files.<br></span></span></div><div><span class="gmail-im"><span class="gmail-im"></span></span></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jan 31, 2019 at 4:43 PM Ian Campbell <<a href="mailto:ijc@hellion.org.uk">ijc@hellion.org.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Thu, 2019-01-31 at 15:43 +1300, Stephen Worthington wrote:<br>
> If that does not work, then you will need to create a<br>
> virtual PC and install the old system on it, with the matching version<br>
> of MySQL or MariaDB, then copy those files onto the virtual PC and run<br>
> <a href="http://mythconverg_backup.pl" rel="noreferrer" target="_blank">mythconverg_backup.pl</a> there.  There is no need to install MythTV on<br>
> the virtual machine.<br>
<br>
He could almost certainly get away with a container or even a plain old<br>
chroot, of the previous Fedora release which might be less faff to<br>
setup.<br>
<br>
Ian.<br>
<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div>