[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