[mythtv-users] Still stuck...MythTV Dead

Steve Daniels steve.p.daniels at googlemail.com
Tue May 23 17:28:33 UTC 2006


> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> bounces at mythtv.org] On Behalf Of Tom Dale
> Sent: 23 May 2006 15:24
> To: mythtv-users at mythtv.org
> Subject: [mythtv-users] Still stuck...MythTV Dead
> 
> I realize that my previous thread may have been
> difficult to follow, but
> with the help I got from several folks, I believe that
> we've narrowed
> down the problem.  I'm sure that someone here can help
> me.  I completely
> re-installed from scratch using Mythdora and restored
> my database per
> the MythTV FAQ.  Live TV does not work, prior
> recordings do not show up,
> MythWeb displays errors.  This box has run for over a
> year with various
> Fedora or Mythdora installations.  I don't know what
> broke it, but
> restoring the database seems to restore the problem.
> Thanks to help
> from this list, here's what I found in my
> mythbackend.log that looks
> suspicious:
> 
> > 2006-05-20 03:02:24.244 DB Error (Error in
> JobQueue::GetJobs(), Unable
> > to query list of Jobs in Queue.):
> > Query was:
> > SELECT j.id, j.chanid, j.starttime, j.inserttime,
> j.type, j.cmds,
> > j.flags, j.status, j.statustime, j.hostname, j.args,
> j.comment,
> > r.endtime FROM jobqueue j, recorded r WHERE j.chanid
> = r.chanid AND
> > j.starttime = r.starttime ORDER BY j.inserttime,
> j.chanid, j.id;
> > Driver error was [2/1146]:
> > QMYSQL3: Unable to execute query
> > Database error was:
> > Table 'mythconverg.jobqueue' doesn't exist
> 
> To see the full contents of the log, mysqld.log, error
> logs and previous
> thread history, see
> 
> http://www.gossamer-threads.com/lists/mythtv/users/204612
> 
> Thank you, in advance, for any help you can provide!
> -Tom-
> 

Hi Tom,

When you did the fresh install, before you restored the db, did live tv
work? Did mythweb work?

Can you check that the jobqueue table exists or not in the mythconverg
database?

Can you verify it exisists in the backup?

What steps did you follow?

These?

http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5

23.5 Saving or restoring the database

See the mysqldump manpage for more information.

    $ mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql

To restore: (assuming that you've dropped the database)

    $ mysql -u root
    mysql>create database mythconverg;
    mysql>exit
    $ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql

You may need to alter the MySQL permissions if this database is being shared
with multiple systems. See the Modifying access to the MySQL database for
multiple systems section for more information.

If you can scrub the entire database (keeping you back up) then start a new
database, get myth configured and working.

Then once it's all working, live tv, mythweb etc, follow these instructions
from a tiny bit down from where the above are.

http://www.mythtv.org/docs/mythtv-HOWTO.html#toc23.7

This assumes that you will be moving your data to newer / bigger hardware
and don't want to lose your programs.

The first step is to create a database backup as demonstrated in an earlier
section.

Next, you will extract only the data that is relevant to the programs:

    $ grep "INSERT INTO record "         mythtv_backup.sql > restore.sql
    $ grep "INSERT INTO recorded "       mythtv_backup.sql >> restore.sql
    $ grep "INSERT INTO oldrecorded "    mythtv_backup.sql >> restore.sql
    $ grep "INSERT INTO recordedmarkup " mythtv_backup.sql >> restore.sql

NOTE: Newer versions of mysqldump place backticks around the table names.
Backticks are not the same as apostrophes! On a typical North American
keyboard, backticks are located to the left of the "1" key, on the same key
as the tilde. Also, because the bash shell may try to interpret the
backticks, make sure you use a \ before each one.

If your restore.sql file is empty, you'll need to re-run the commands like
this:

    $ grep "INSERT INTO \`record\` "         mythtv_backup.sql > restore.sql
    $ grep "INSERT INTO \`recorded\` "       mythtv_backup.sql >>
restore.sql
    $ grep "INSERT INTO \`oldrecorded\` "    mythtv_backup.sql >>
restore.sql
    $ grep "INSERT INTO \`recordedmarkup\` " mythtv_backup.sql >>
restore.sql

Note the space after the table name and the ">>" to append to the file for
all but the first grep. "recordedmarkup" is huge and may be hundreds of
thousands of lines if you had lots of hours of recordings.

After you have moved the data files to the new hardware, configure MythTV
using the mythtv-setup program as you normally would with a standard MythTV
installation.

At this point we will restore the information about your programs back into
the database:

    $ mysql -u mythtv -pmythtv mythconverg < restore.sql 

After successful insertion of the data you may delete the restore.sql file.


Hope that helps :-)

Steve Daniels


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.7.0/345 - Release Date: 22/05/2006
 



More information about the mythtv-users mailing list