[mythtv-users] Installing MythTV on a system with a pre-existing MySQL database

[Michael T. Dean]

  On 01/27/2011 10:36 PM, Dan Wilson wrote:
> On 01/27/2011 05:31 PM, Dani wrote:
>> [I am a MythTV newbie so apologies if I am missing anything obvious. 
>> Ilooked through the archives but could not find an answer to this 
>> query.]
>>
>> I am installing MythTV on a system (Ubuntu 10.10) that is already 
>> hosting a Bitnami Mediawiki stack which includes an instance of 
>> MySQL, currently only used for the Mediawiki.
>>
>> I am considering whether to run an instance of MySQL dedicated to 
>> MythTV in addition to the one used for Mediawiki or to use the same 
>> MySQL for both the Mediawiki stack and MythTV.
>>
>> Questions:
>>
>> 1. What would be considered the best-practice?
> I can't speak to the "best-practices" for the whole industry, but I am 
> running multiple databases, including mythtv, using mysql on my master 
> backend, and it works fine. I would expect more problems from trying 
> to run multiple instances of mysql than you'd get from running 
> multiple databases under a single mysql instance.

Agreed.  As long as you don't need to take the MySQL server down 
randomly to fix problems with other applications, it should be fine to 
use it for multiple databases.

>> 2. Other than adding a mythtv user to the existing MySQL database and 
>> running mysql -u root < /usr/share/mythtv/sql/mc.sql, is there 
>> anything else I need to add to the existing MySQL to prepare it for 
>> MythTV?
>>
> Just follow the directions - mysql should just pick up the new 
> database and run with it.

Yep.

Mike