<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<p> </p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Folks!</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Last night at the
very end of watching shows on a remote Frontend had a problem
where
the FE couldn’t find the database – show completed fine, we play
a game of how many hours on the Information screen (the one before
the one listing deleted shows) – all blank fields. At the FE
exited Myth, tried commandline ‘mythfrontend’ – error something
like can’t find backend database.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Running MythTV v30
under Ubuntu 18.04.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">This morning the
Backend required a manual <font face="Liberation Mono, monospace">fsck
/dev/sda2</font>. Didn’t quick take so ran <font
face="Liberation Mono, monospace">fsck
-fy /dev/sda2</font> and followed that with GRUB > Recovery
Mode>
DPKG to fix. (I’m following a post in AskUbuntu.com.) </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Backend now
working;
tested and the recorded shows are there and play. Did see an error
about “is mythfilldatabase running?”; figured that would resolve
itself at the pre-scheduled run to SchedulesDirect later in the
morning. Nope.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Database error:</p>
<p style="margin-bottom: 0in; line-height: 100%">Table
‘./mythconvverg/program’ is is marked as crashed and last
(automatic ) repair failed</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Googled: tried
various myisamchk options – eventually I did a find for *.MYI
(used
iname for the case-insensitive option): no *.MYI anywhere.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Did try <font
face="Liberation Sans Narrow, sans-serif">service
mysql status ==> active (running)</font></p>
<p style="margin-bottom: 0in"><font face="Liberation Sans Narrow,
sans-serif"> fatal:
open /etc/postfix/main.cf: no such file or directory</font></p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Later thought of </p>
<p style="margin-left: 0.49in; margin-bottom: 0in; line-height:
100%">
<a href="https://www.mythtv.org/wiki/Database_Backup_and_Restore"><font
face="Norasi"><font style="font-size: 10pt" size="2">https://www.mythtv.org/wiki/Database_Backup_and_Restore</font></font></a></p>
<h4 class="western" style="margin-left: 0.49in">Full restore of a
specific backup file</h4>
<p style="margin-left: 0.49in">Change the directory and filename, as
required: </p>
<pre class="western" style="margin-left: 0.49in; margin-bottom: 0.2in">mythconverg_restore.pl --directory /home/mythtv --filename mythconverg-1214-20080626150513.sql.gz</pre>
<p style="margin-left: 0.49in; margin-bottom: 0in; line-height:
100%"> BE3 ==> /home/barry/Mythtv</p>
<p style="margin-bottom: 0in; line-height: 100%">Seems mine wants
the
fullpath even though I’m in the correct directory.</p>
<p style="margin-bottom: 0in; line-height: 100%">Here is
‘home/barry/Mythtv.</p>
<p style="margin-bottom: 0in; line-height: 100%">The source filename
– says “The specified backup file does not exist”. (Error
says stopped at line 845 if that helps any.) I pulled it in from
the
GUI file cabinet, tried with and without the full path. ls says
it’s
there. </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Help! Now what
should I do?!</p>
<p style="margin-bottom: 0in; line-height: 100%">Thanks!</p>
<p style="margin-bottom: 0in; line-height: 100%">Barry </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p>
<style type="text/css">h4.cjk { font-family: "Noto Sans CJK SC" }h4.ctl { font-family: "Lohit Devanagari" }pre.cjk { font-family: "Courier New", monospace }p { margin-bottom: 0.1in; line-height: 115% }a:link { so-language: zxx }</style></p>
</body>
</html>