[mythtv-users] MythTV MySQL setup didn't work

[emarkert at aim.com]

> mysql -u root -p < /usr/share/doc/mythtv-docs-0.22/database/mc.sql
>
> needs to be
>
> mysql -u root -p mythconverg <
> /usr/share/doc/mythtv-docs-0.22/database/mc.sql
>
> and you likely would have needed to create the database first
>
> mysqladmin -uroot -p create mythconverg
>

<Please don't top post on this list>

>That is all incorrect. the mc.sql is precisely what creates the
>database for you, along with setting the correct attributes that the
>DB schema creation and upgrade path that mythbackend follow expects.
>You do *not* need to create the DB first, and you definitely don't
>want to run the DB creation script on the database it itself creates.

Actually, it's not all wrong.  I answered the question.  The mysql commands I gave him are correct, and the DDL language in the mc.sql file will create the database as you mention, but if the database already exists it will skip that command.  

Should I have mentioned that?  Maybe.

Nowhere in my email did I say the user should be doing this by hand, but the gist of the original email was that the install failed, which does happen sometimes.  I've had it happen on two occasions upgrading a myth 0.22 package.

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100116/a8a01648/attachment.htm>