[mythtv-users] Mythtv database requirements??

[James Abernathy]

On Mon, Mar 30, 2020 at 10:15 AM Stephen Worthington <
stephen_agent at jsw.gen.nz> wrote:

> On Mon, 30 Mar 2020 08:46:00 -0400, you wrote:
>
> >
> >On 3/30/20 8:14 AM, Stephen Worthington wrote:
> >>
> >> No, there is no problem with restoring a backup.  The backup files are
> >> SQL statements, so they will run on anything that will accept the SQL
> >> being used.  The problem is when you try to change from MySQL to
> >> MariaDB and get MariaDB to just do a binary fix to convert the MySQL
> >> tables into MariaDB tables.  It finds no path it can use to do that
> >> conversion due to a mismatch of MySQL version against MariaDB version.
> >> So it leaves the database in MySQL format and tells you it is unable
> >> to convert it.  It seems to be a problem with the point versions.  I
> >> suspect that if you were coming from MySQL 5.7.0 and converting to
> >> MariaDB 10.0.0, it would work.  But from say MySQL 5.7.1 to say
> >> MariaDB 10.0.4, it does not work as no-one has created code for any
> >> binary format changes in both programs to match up between them.  So
> >> it is a pain but not a show stopper problem - just do a backup, change
> >> to MariaDB and do a restore.  But you do need to remember to do the
> >> backup before you change the database engine!
> >
> >So from what you said does this work?
> >
> >1. backup mythtv-database on working Ubuntu 18.04 system running mythtv
> >v31 using MariaDB 10.1.
> >
> >2. build new Ubuntu 18.04 system
> >
> >3. install mythtv v31, from ppa:mythbuntu/31 which installs MySQL 5.7.
> >
> >4. restore mythtv-database from #1.
> >
> >Not sure I'll change at this point, but if I have to completely rebuild
> >with new hardware I might try it.
> >
> >Jim A
>
> Yes.  I have never tried it that direction, but that is the way it
> works converting to MariaDB and there is no reason for it not to work
> the other way.
>
> Okay, just did an experiment and it worked with a few modifications so my
new instructions would be:
 1. backup mythtv-database on working Ubuntu 18.04 system, hostname
'mythbuntu', running mythtv v31 using MariaDB 10.1.
 2. build new Ubuntu 18.04 system keeping hostname 'mythbuntu'
 3. install mythtv v31, from ppa:mythbuntu/31 which installs MySQL 5.7.
 4. setup xmltv and setup tv_grab_zz_sqlite so SD is the same as on
previous system.
 5. Run mythtv-setup so the 'mythtv' user gets created logout/reboot.
 6. Run mythtv-setup and setup general database part, save and exit
 7. restore database from other system's backup.
 8. complete mythtv-setup for changes need for tuners, video sources, and
input connections.
 9. sudo su mythtv   and run mythfilldatabase

This all worked, but I could not restore database until mythtv-setup was
run at least as described above. Keep hostname the same was critical as
well.

Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20200330/d28ce2fa/attachment.htm>