Hi All,<br>got mythbuntu FE/BE combined on a single machine, all was perfectly working fine till about 3 weeks ago.<br>For no apparent reason all recordings went missing one morning.<br>I found at first that it might be "length mismatch" problem with bookmarks (<a href="http://www.gossamer-threads.com/lists/mythtv/users/442344">http://www.gossamer-threads.com/lists/mythtv/users/442344</a>) so upgraded to autobuilds 0.23.1 but no luck.<br>
Then found out that it might be corrupted database and follow these steps (<a href="http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043&postdays=0&postorder=asc&start=0">http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043&postdays=0&postorder=asc&start=0</a>) - basically - myisamchk *.MYI <-- showed NO warnings<br>
<br>Checking MyISAM file: recordedseek.MYI<br>Data records: 734046 Deleted blocks: 0 <-- thats the highest number of data records (but probably its ok)<br>- check file-size<br>- check record delete-chain<br>
- check key delete-chain<br>- check index reference<br>- check data record references index: 1<br> <br><br>Checking MyISAM file: recorded.MYI<br>Data records: 203 Deleted blocks: 52<br>- check file-size<br>- check record delete-chain<br>
- check key delete-chain<br>- check index reference<br>- check data record references index: 1<br>- check data record references index: 2<br>- check data record references index: 3<br>- check data record references index: 4<br>
- check data record references index: 5<br>- check data record references index: 6<br>- check data record references index: 7<br>- check data record references index: 8<br>- check record links<br><br>---------<br><br>Checking MyISAM file: recordedprogram.MYI<br>
Data records: 197 Deleted blocks: 0<br>- check file-size<br>- check record delete-chain<br>- check key delete-chain<br>- check index reference<br>- check data record references index: 1<br>- check data record references index: 2<br>
- check data record references index: 3<br>- check data record references index: 4<br>- check data record references index: 5<br>- check data record references index: 6<br>- check data record references index: 7<br>- check record links<br>
<br><br><br>Couldnt log in to mysql so managed to set root password and now it lets me in only as root, -umyhttv doesnt seems to work, which i would thought might be a problem but checked all mysql.txt and all seems to have same settings (passwords) and the frontend does show some of DB (like upcoming recordings etc.) Live TV also works fine. All recordings are physically on my hdd as thats the only way to watch them now.<br>
<br>Any more ideas what it might be?<br><br>Regards<br><br>Alex<br>