[mythtv-users] How to create just one table in mythconverg
william_munson at bellsouth.net
Mon Sep 3 10:58:58 UTC 2007
Lan Barnes wrote:
> Somehow either in upgrading to 0.20.2 or ... whatever ... I lost the
> recordseek table.
> Things seem to work but that can't be good.
> Is there a way to restore just one table in mythconverg, or should I make
> a dump, drop the data base, and recreate it? And if the latter, I'd
> appreciate a URL of the procedure, because my wiki searching sucks.
> >From my log.
> 2007-09-02 18:29:26.891 DB Error (delta position map insert):
> Query was:
> INSERT INTO recordedseek (chanid, starttime, mark, type, offset) VALUES (
> '1043' , '2007-09-02T17:31:00' , '7016' , 6 , '2
> 276712448' );
> Driver error was [2/29]:
> QMYSQL3: Unable to execute query
> Database error was:
> File './mythconverg/recordedseek.MYD' not found (Errcode: 2)
Before you get creative try running the myth-optimize-db script from the
contrib folder. That should fix your database unless its really badly
mucked up. I run it weekly from a cron job.
More information about the mythtv-users