[mythtv-users] mythfilldatabase error -- Can't open file: 'credits.MYD'. (errno:145)

Bruce Markey bjm at lvcm.com
Mon May 31 13:48:59 EDT 2004


Gerald Schepens wrote:
> Mythfilldatabase produces an error, which it didn't have before.  It's 
> run post-0.15 release already withouth any trouble.  Anyway, the output 
> below shows the error is something to do with a credits table insert 
> that didn't work.
> 
> Main temp tables populated.  Updating myth channels...
> Channels updated..  Updating programs...
> DB Error (Inserting into credits table):
> Query was:
> INSERT IGNORE INTO credits (chanid, starttime, person, role) SELECT 
> chanid, starttime, person, role FROM dd_productioncrew, dd_v_program, 
> people WHERE ((dd_productioncrew.programid = dd_v_program.programid) AND 
> (dd_productioncrew.fullname = people.name));
> Driver error was [2/1016]:
> QMYSQL3: Unable to execute query
> Database error was:
> Can't open file: 'credits.MYD'. (errno: 145)
> 
> If I try to query the credits table using mysql directly, I get the same 
> error:  "Can't open file 'credits.MYD'. (errno: 145)".  Something on my 
> system's gotten messed up, obviously.  What's the fix?


mysqlcheck -r -u mythtv -pmythtv mythconverg

--  bjm


More information about the mythtv-users mailing list