[mythtv-users] Restore Database from Old Database Files -- No Backup

[George Galt]

Hmm, OK, so I copied all of the backed-up files from
/backupdisk/var/lib/mysql/mythconverg
to the active /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:

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mythconverg        |
+--------------------+

and I can show the tables in mythconverg:

MariaDB [(none)]> use mythconverg;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mythconverg]> show tables;
+--------------------------------+
| Tables_in_mythconverg          |
+--------------------------------+
| archiveitems                   |
| bdbookmark                     |
| callsignnetworkmap             |
| capturecard                    |
| cardinput                      |
| channel                        |
| channelgroup                   |

But if I try to access one of the tables, I get an error saying that it
doesn't exist:

MariaDB [mythconverg]> describe scannerfile;
ERROR 1146 (42S02): Table 'mythconverg.scannerfile' doesn't exist
MariaDB [mythconverg]> select * from settings;
ERROR 1146 (42S02): Table 'mythconverg.settings' doesn't exist

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.

I did shut down mysql before moving the files.

On Thu, Jan 31, 2019 at 4:43 PM Ian Campbell <ijc at hellion.org.uk> wrote:

> On Thu, 2019-01-31 at 15:43 +1300, Stephen Worthington wrote:
> > If that does not work, then you will need to create a
> > virtual PC and install the old system on it, with the matching version
> > of MySQL or MariaDB, then copy those files onto the virtual PC and run
> > mythconverg_backup.pl there.  There is no need to install MythTV on
> > the virtual machine.
>
> He could almost certainly get away with a container or even a plain old
> chroot, of the previous Fedora release which might be less faff to
> setup.
>
> Ian.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190201/55b3400d/attachment.html>