<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.16.1">
</HEAD>
<BODY>
Ok, I too believe mysql is very reliable but our demo box had a corrupted recordings table over the weekend, it required a full rebuild of the table under mysql tools.<BR>
We so far have no idea what caused it. This one runs ubuntu hardy. Having said that, we have instituted a few more controls over the power button :-) You never know how a user might attempt to solve a problem.<BR>
I had to reboot the home unit yesterday morning due to our skystar cards being unable to get more than a partial lock under mythfrontend. They were fine in scripts or mythsetup!<BR>
Puzzles puzzles.<BR>
Barry<BR>
<BR>
On Mon, 2008-07-07 at 20:26 +1200, Steve Holdoway wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">On Mon, 07 Jul 2008 17:44:15 +1200</FONT>
<FONT COLOR="#000000">AlanP <<A HREF="mailto:alan.p@orcon.net.nz">alan.p@orcon.net.nz</A>> wrote:</FONT>
<FONT COLOR="#000000">> This time, KnoppMyth reckons that the mysql.hosts table is in the wrong </FONT>
<FONT COLOR="#000000">> format, and mysqld will not bloody load. Stupid bloody unstable thing. I'm </FONT>
<FONT COLOR="#000000">> tempted to backup all the recordings to a 1TB drive, install XP and put </FONT>
<FONT COLOR="#000000">> Media Portal or MCE or something on it.</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Anyone know how to fix this? I tried myisamchk -r on the </FONT>
<FONT COLOR="#000000">> /var/lib/mysql/mysql/host.MYI file, no joy.</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">if you make a backup, and try to fix...</FONT>
<FONT COLOR="#000000">cd /var/lib/mysql/mysql</FONT>
<FONT COLOR="#000000">mkdir save</FONT>
<FONT COLOR="#000000">cp *MYI save</FONT>
<FONT COLOR="#000000">myisamchk --force --fast --update-state *MYI</FONT>
<FONT COLOR="#000000">you should have some luck restarting the database server. If you can get mysql up without privileges, then the following will create an empty host table ( mysql 5.0 ):</FONT>
<FONT COLOR="#000000">SET character_set_client = utf8;</FONT>
<FONT COLOR="#000000">CREATE TABLE `host` (</FONT>
<FONT COLOR="#000000"> `Host` char(60) collate utf8_bin NOT NULL default '',</FONT>
<FONT COLOR="#000000"> `Db` char(64) collate utf8_bin NOT NULL default '',</FONT>
<FONT COLOR="#000000"> `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Create_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Show_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Create_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Alter_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N',</FONT>
<FONT COLOR="#000000"> PRIMARY KEY (`Host`,`Db`)</FONT>
<FONT COLOR="#000000">) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges; Merged with database privileges';</FONT>
<FONT COLOR="#000000">However, mysql is just not that unreliable - millions of websites out there run on it! There must be a cause for this database corruption, and knoppmyth isn't it. Power? Hardware? Any info in the mysql logs, or the system ones??</FONT>
<FONT COLOR="#000000">Steve</FONT>
</PRE>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<TABLE WIDTH="70%">
<TR>
<TD>
<IMG SRC="cid:1215419990.15268.8.camel@mordecai2.bcsystems.co.nz" ALIGN="bottom" BORDER="0">
</TD>
<TD>
18 Shaw Street<BR>
Mosgiel<BR>
<A HREF="mailto:barryc@bcsystems.co.nz">mailto:barryc@bcsystems.co.nz</A> <BR>
ph 03 4893915<BR>
mob 027 2219338
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>