Somehow I have hosed my channel table and am unable to repair it. While running mythfilldatabase I got the following error:
Quote: 2006-01-04 19:16:12.437 DB Error (checking existing program data):
Query was:
SELECT COUNT(*) FROM program LEFT JOIN channel USING (chanid) WHERE sourceid = 1 AND starttime >= DATE_ADD(CURRENT_DATE(), INTERVAL '13 18' DAY_HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL 14 DAY)
Driver error was [2/1017]:
QMYSQL3: Unable to execute query
Database error was:
Can't find file: 'channel.MYI' (errno: 2)
Data is already present for Tue Jan 17 2006, skipping
2006-01-04 19:16:12.466 New DB connection, total: 4
Adjusting program database end times...
0 replacements made.
2006-01-04 19:16:12.483 mythfilldatabase: Listings Download Finished
Marking repeats...found 0
Unmarking repeats from grabber that fall within our new episode window...found 0
2006-01-04 19:16:12.506 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
In sql manager I tried
Code: repair table channel;
but recieve this error:
Output from SQL command repair table channel; ..
Table Op Msg_type Msg_text
mythconverg.channel repair error Can't find file: 'channel.MYI' (errno: 2)
any suggestions for repairing or reloading the table?
|
