<font color='black' size='2' face='arial'>
<div style="clear: both;"></div>
<div style="font-family: helvetica,arial; font-size: 10pt; color: black;">
<div id="AOLMsgPart_0_4b2a8fe8-91ff-4d0c-be35-c3a89a8d5b60" style="margin: 0px; font-family: Tahoma,Verdana,Arial,Sans-Serif; font-size: 12px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><pre style="font-size: 9pt;"><tt>> mysql -u root -p < /usr/share/doc/mythtv-docs-0.22/database/mc.sql<br>
><br>
> needs to be<br>
><br>
> mysql -u root -p mythconverg <<br>
> /usr/share/doc/mythtv-docs-0.22/database/mc.sql<br>
><br>
> and you likely would have needed to create the database first<br>
><br>
> mysqladmin -uroot -p create mythconverg<br>
><br>
<br>
<Please don't top post on this list><br>
<br>
</tt><font size="2"><font face="Arial, Helvetica, sans-serif">></font></font><tt>That is all incorrect. the mc.sql is precisely what creates the<br>
</tt><font size="2"><font face="Arial, Helvetica, sans-serif">></font></font><tt>database for you, along with setting the correct attributes that the<br>
</tt><font size="2"><font face="Arial, Helvetica, sans-serif">></font></font><tt>DB schema creation and upgrade path that mythbackend follow expects.<br>
</tt><font size="2"><font face="Arial, Helvetica, sans-serif">></font></font><tt>You do *not* need to create the DB first, and you definitely don't<br>
</tt><font size="2"><font face="Arial, Helvetica, sans-serif">></font></font><tt>want to run the DB creation script on the database it itself creates.<br>
<br>
</tt><font size="3"><font face="Arial, Helvetica, sans-serif"><font face="Times New Roman, Times, serif">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. <br>
<br>
Should I have mentioned that? Maybe.<br>
<br>
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<font face="Arial, Helvetica, sans-serif">, which does happen </font></font>sometimes. I've had it happen on two occasions upgrading a myth 0.22 package.<br>
</font></font></pre>
</div>
<!-- end of AOLMsgPart_0_4b2a8fe8-91ff-4d0c-be35-c3a89a8d5b60 -->
</div>
</font>