[mythtv-users] Mythbuntu change from MySQL to MariaDB?
Jim Abernathy
jfabernathy at outlook.com
Thu Aug 25 09:33:28 UTC 2016
On 08/24/2016 10:41 PM, Stephen Worthington wrote:
> On Wed, 24 Aug 2016 17:16:22 -0400, you wrote:
>
>>
>> On 08/24/2016 04:59 PM, nospam312 wrote:
>>> On 22 August 2016 at 12:08, Jim Abernathy <jfabernathy at outlook.com
>>> <mailto:jfabernathy at outlook.com>> wrote:
>>>
>>>
>>> http://www.mythbuntu.org/downloads
>>> <http://www.mythbuntu.org/downloads>
>>>
>>>
>>> Thanks for your replies but I do not know if you are trying to wind me
>>> up or not.
>>>
>>> I can see no reference to a MariaDB version on that page just the
>>> standard Mythbuntu download?
>>>
>>> Can you help with a specific download for the ISO with MariaDB used
>>> instead of MySQL?
>>>
>>> To get a clean install would be worth the effort instead a more than
>>> perfect removal of MySQL and then install of MariaDB.
>>>
>> I'm not smart enough to know MySQL from MariaDB. I just downloaded
>> mythbuntu from the download site, burn it to a CDROM or USB key and
>> install it. The database always takes care of itself. I only rebuild
>> when I have all my recordings archived to a NAS and my database is
>> basically empty. I rebuild it before the fall TV season starts. So now
>> I'm committed to Mythbuntu 14.04.4 until next year because of issues I'm
>> having with 16.04. I can get 16.04 working except for 2 issues that are
>> not DB related. Just related to my TV and A/V receiver. There is also
>> a bug with mythtranscode that has not been fixed so I'm staying on
>> mythtv 0.27
>>
>> So even though I've tested a lot on 0.28, and 16.04, I still have no
>> idea why you are worried about MySQL vs. MariaDB. I still use mysql
>> commands on 16.04. So I'm unaware of any changes in that area.
>>
>> I have to mottoes to live by.
>> 1. if it ain't broke don't fix it and
>> 2. You can't drink all day if you don't start in the morning.
>>
>> Jim A
> I am converting to using MariaDB in 16.04 due to MySQL changing from
> using the readline library to editline. Editline does not work for me
> in bringing back SQL commands from history, which I find extremely
> aggravating since readline works very well and I use the history all
> the time. Apparently Oracle do not want readline's GPL or LGPL
> licensing as part of MySQL, so they switched to editline because its
> licensing is more what they want. I find that a problem also, as it
> may indicate that Oracle are trying to make MySQL proprietary somehow
> instead of freeware.
>
> MariaDB is extremely compatible with MySQL and it is actually hard to
> tell which one is installed without looking hard. The MariaDB
> packages directly replace the MySQL ones (using the same executable
> names) and provide all the same commands and services. The only
> difference that I found that I had to deal with was that MariaDB has
> some config files that belong to it only and are separate from the
> normal MySQL config files. Doing that, combined with how the MythTV
> packages do their MySQL config and how I had overridden some default
> settings in the MythTV MySQL config did not work with MariaDB as the
> config files ended up being loaded in a different order, so my
> overrides were not being loaded last. That resulted in the IP address
> for accessing the database not being set to my MythTV box's external
> IP address and it was defaulting to localhost. It was easy enough to
> fix once I worked out what was happening.
> ___
So If you do a standard Mythbuntu 16.04 install from CDROM, which
database are you using?
MCC still has a MySQL section
Jim A
> ____________________________________________
> 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
More information about the mythtv-users
mailing list