[mythtv-users] How to create just one table in mythconverg

[William Munson]

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)
>
> TIA,
>
>   
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.