>From the "database gone south" thread, we advance boldly into the future :-)
I ended up having to completely redo the database. I never could figure out what was wrong with it. I dumped the current contents, then got into mysql and did the "drop database mythconverg; source /usr/share/doc/mythtv-0.18.1/database/mc.sql" to recreate empty tables (pretty much what is described in the MySQL chapter of Jarod's guide). Then I went through mythtv-setup on the master backend (MBE), manually restoring the capture card, video sources, and input settings. Then of course I was missing the information to connect the files in /video to what recorded programs they were, so I reloaded (from a database dump taken before this) the "oldrecorded", "recorded", "recordedprogram", and "videometadata" tables. After doing all this, everything appears to be good (almost) on the MBE. I can watch TV (other than not being able to change channels), I can view the saved recordings, I can schedule recordings (apparently), mythweb works, the guide works. The problem is now I cannot change channels in mythfrontend. I *can* change channels with ptune.ui.pl script, and the OSD shows no data, so I'm pretty sure this is still some sort of database problem. I've just run to the end of the rope here, I cannot get my database back and I don't know what else to try. I have rerun mythfilldatabase and restarted mythbackend several times with no effect. The backend produces the following error when I try to change channels: 2005-09-25 13:59:37.866 Channel(/dev/video0): CheckChannel failed. Please verify channel "6" in the "setup" Channel Editor. I have searched the archives for this error message, but none of those threads appear to describe my problem. Is there any way to just recreate the database from scratch? Is it documented how to do this anywhere other than the brief description in Jarod's guide (which I already tried?) I seem to be out of options and my system is fairly useless until I can fix this problem. --Greg
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
