Solution for anyone who might care.<br><br>I had another suse box laying around with mysql 4.1 ...imported the 4.1 dump.<br><br>Ran the following command.<br><br><pre class="programlisting">shell> <strong class="userinput">
<code>mysqldump --create-options --compatible=mysql40 <em class="replaceable"><code>db_name</code></em> > <em class="replaceable"><code>dump_file</code></em></code></strong></pre>you can read the info from here<br><br>
<a href="http://dev.mysql.com/doc/refman/4.1/en/downgrading-to-4-0.html">http://dev.mysql.com/doc/refman/4.1/en/downgrading-to-4-0.html</a><br><br>took the new downgraded dump to the KnoppMyth box with mysql 4.0<br><br>bingo up and running
<br><br><br><div><span class="gmail_quote">On 12/20/06, <b class="gmail_sendername">Ronald Kohsman</b> <<a href="mailto:ronald.kohsman@gmail.com">ronald.kohsman@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I have it narrowed down. You are going to love this.<br><br>FC4 w/mysql 4.1 mysqldump'd<br>new box<br>Knoppmyth (for reasons easiest explained..pchdtv 5500) w/mysql 4.0<br><br>I believe somewhere there is the problem...I would like to retrieve the info. About 1 year and over 600GB of tv shows stored...not enough time to watch.
<br><br>Looking for help...btw...KnoppMyth served its purpose for getting my 250, 350 and pchdtv 5500 all working with little trouble...but not liking the stripped down OS too much. Afraid to punch it around too much and break something and cause troubles.
<br><br>Thanks again.<br><br><br><br><div><span class="q"><span class="gmail_quote">On 12/20/06, <b class="gmail_sendername">Kevin Kuphal</b> <<a href="mailto:kuphal@dls.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
kuphal@dls.net</a>> wrote:</span></span><div><span class="e" id="q_10fa17dd38ecd4c7_2"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Ronald Kohsman wrote:<br>> If you mean mysql command line import....did that with no success.<br>> Error on CHARSET=latin1.<br>How you import the database is really a question for mysql. I can only<br>suggest reading the documentation on
<a href="http://mysql.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mysql.com</a><br><br>Kevin<br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></span></div></div><br><br clear="all"><div><span class="e" id="q_10fa17dd38ecd4c7_4"><br>-- <br>Ronald Kohsman<br>Secure Applications Group<br>
(614) 530-0911 Direct<br><a href="mailto:ronald.kohsman@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
ronald.kohsman@gmail.com</a>
</span></div></blockquote></div><br><br clear="all"><br>-- <br>Ronald Kohsman<br>Secure Applications Group<br>(614) 530-0911 Direct<br><a href="mailto:ronald.kohsman@gmail.com">ronald.kohsman@gmail.com</a>