[mythtv-users] Scheduled Recordings Vanished

[Michael Halcrow]

On Thu, Mar 02, 2006 at 11:01:18PM -0500, Michael T. Dean wrote:
> On 03/02/2006 08:45 PM, Michael Halcrow wrote:
> > My Scheduled Records list mysteriously vanished earlier today. It
> > restored itself after I manually ran mythfilldatabase (I am using
> > Zap2It). I suspect that there was a glitch w/ Zap2It that wound up
> > blowing away the lineup information in the local MythTV database
> > on the update this morning. Some shows I wanted to record didn't
> > get recorded. Anyone else ever have this issue?
> 
> If your program listings disappeared, I'd guess you're using 0.18.x 
> because 0.19 will not delete listings when no data is received.  If your 
> program listings did not disappear and only your scheduled recordings 
> did, I'd guess you're using 0.19 and MySQL 5.0 ( 
> http://www.gossamer-threads.com/lists/mythtv/users/186471#186471 )

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?

Thanks,
Mike
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 481 bytes
Desc: Digital signature
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20060306/af553e87/attachment.pgp