[mythtv-users] !!NoTrans: SQL Error: Table

Dick Steffens dick at dicksteffens.com
Mon Dec 12 19:27:42 UTC 2016


On 12/12/2016 11:19 AM, Romain Kang wrote:
> Sorry about that -- I got confused by some cruft I have that goes back
> to around 2004.  I think the place to find the mythtv password is
> in /etc/mythtv/config.xml.
Okay. Found it.

...

>From the shell, run
     $ mysql -umythtv -p mythconverg
When prompted for as password, use the one from ~mysql/.my.cnf

Then at the mysql prompt:
     mysql> repair table program;

---------------------------------------------------
mysql> repair table program;
+---------------------+--------+----------+--------------------------------------------------------+
| Table               | Op     | Msg_type | Msg_text                                               |
+---------------------+--------+----------+--------------------------------------------------------+
| mythconverg.program | repair | error    | Can't create new tempfile: './mythconverg/program.TMD' |
| mythconverg.program | repair | status   | Operation failed                                       |
+---------------------+--------+----------+--------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>
---------------------------------------------------



-- 
Regards,

Dick Steffens



More information about the mythtv-users mailing list