[mythtv-users] Scheduled Recordings Vanished

Greg Farrell greg at gregfarrell.org
Tue Mar 7 10:01:11 UTC 2006


On Mon, 2006-03-06 at 22:04 -0600, Michael Halcrow wrote:

> So what's the recommended workaround for now?
> 
> If it involves downgrading to a prior version of MySQL, which version
> is recommended? If it's around version 4.0, what to do about
> CURRENT_TIMESTAMP, DEFAULT CHARSET, and so forth in the resulting
> mysqldump file that version 5.0 generates?

If this is the mysql 5.x problem with idle connections timing out and
mythtv not reconnecting then try putting:

connect_timeout         = 2592000
wait_timeout            = 2592000

in your /etc/mysql/my.cnf Then restart mysql and your mythtv backend.

I'm pretty sure it's just the wait_timeout one you need, but I stuck
both in and it fixed the problem, so I didn't bother to narrow it down
further.

This'll stop your mysql connections timing out due to idleness for up to
30 days.

    Greg




More information about the mythtv-users mailing list