[mythtv-users] Mythtv database requirements??

Stephen Worthington stephen_agent at jsw.gen.nz
Mon Mar 30 14:13:08 UTC 2020


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.


More information about the mythtv-users mailing list