I'm using ubuntu 7.10 about to upgrade to 8.04<br><br>in my.conf:<br># * InnoDB<br>#<br># InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.<br># Read the manual for more InnoDB related options. There are many!<br>
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.<br>#skip-innodb<br><br><pre>On 05/02/2008 02:40 PM, J wrote:<br><br></pre><blockquote type="cite"><pre><span class="moz-txt-citetags">> </span> From: "Michael T. Dean"<br>
<span class="moz-txt-citetags">></span>
</pre><blockquote type="cite"><pre><span class="moz-txt-citetags">> > </span>On 05/02/2008 11:14 AM, J wrote:<br><span class="moz-txt-citetags">> ></span>
</pre><blockquote type="cite"><pre><span class="moz-txt-citetags">> >> </span>When I updated my mythtv the database didn't like it and the<br><span class="moz-txt-citetags">> >> </span>weather part broke, I tired running repairs but how can I fix it?<br>
<span class="moz-txt-citetags">> >> </span>thank you!<br></pre></blockquote><pre><span class="moz-txt-citetags">> ></span><br><span class="moz-txt-citetags">> > </span>MythWeather <i class="moz-txt-slash"><span class="moz-txt-tag">/</span>requires<span class="moz-txt-tag">/</span></i> that you enable InnoDB tables in MySQL. If<br>
<span class="moz-txt-citetags">> > </span>anyone tells you, "Just do this ... to change it to use MyISAM,"<br><span class="moz-txt-citetags">> > </span>don't follow their advice as it is broken advice that will break<br>
<span class="moz-txt-citetags">> > </span>your Myth box.<br></pre></blockquote><pre><span class="moz-txt-citetags">></span><br><span class="moz-txt-citetags">> </span> What is InnoDB?<br></pre></blockquote><pre>
<br>It's a MySQL storage format.<br><br></pre><blockquote type="cite"><pre><span class="moz-txt-citetags">> </span> and how do I enable it?<br></pre></blockquote><pre><br>Don't start the server with --skip-innodb and don't put the skip-innodb <br>
option in the MySQL option file (/etc/my.cnf) (and don't do any of the <br>other things some crazy distro might do to disable InnoDB storage on <br>your MySQL server).<br><br>In other words, you're probably going to have to tell us what distro <br>
you're using so someone using that same distro can tell you how to undo <br>what the distro did.<br><br>Mike<br></pre><br><br>