<div><span class="gmail_quote">On 11/15/05, <b class="gmail_sendername">Nada De nada</b> <<a href="mailto:marromzinho02@yahoo.com">marromzinho02@yahoo.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Thank for the advice</div>
<div> </div>
<div> but how can I find out in which file my recordings are so I can delete them... i thought that they were being stored on dev/hda5/ but clearl they are not sincey my dev/hda2 partition is full and that does let me log in as user.... is there a way that i can search for files by date and time so I can try to guess which one have the movies that I recorded and delet them
</div>
<div>i would try using the command that you suggest to try to start mysql... it will be nice to be able to tun mythbackend or fronend as root</div>
<div>I also have another problem now... i rebooted the comp and now it doesn;t even start... its frozen in the part that says "Initializing hardware....... storage network"..... some one suggested to use Partitionmagic to try to change partitions and maybe be able to login as user and delete my recordings
</div>
<div> </div>
<div> Thanks</div>
<div> <br> </div>
<div><br><b><i>pete <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:grooveloop7@yahoo.com" target="_blank">grooveloop7@yahoo.com</a>></i></b> wrote:</div>
<div> </div>
<div>you could probably even keep your recordings. move them onto /dev/hda5 and<br>symlink them back to their original locations on /dev/hda2. make sure you<br>enable the config option in the frontend to follow symlinks when deleting
<br>recordings, though. then go into your mysql data directory as root and run<br>myisamchk -f *.ISM (i think that's right check the manpage for myisamchk to be<br>sure) to hopefully fix any corrupted database tables - do that with the backend
<br>shutdown if it managed to start. then reboot and see if it comes up cleanly<br>and starts everything.... If that doesn't work, just delete the recordings<br>and then in mysql you can "delete from recorded where recordid>0" or similar to
<br>clear out that table. that should get you up and running, too.<br><br>before you do ANYTHING else though, do a mysqldump of the mythconverg<br>database onto /dev/hda5 so you can restore anything if it gets hosed...<br>
<br> </div>
<div> </div>
<div> </div>
<blockquote style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">> I can log in as root but I am not being able to run mythtv because Mysql is <br>>not working for some reason and i can not get it to start.....
<br>> Is there anyway that I can go and delete the movies that were recorded so I <br>>can log in as a use... or what can I do to fix this problem. ( i checked using<br><br>>Kdiskfree and my dev/hda2 is full while I have a lot of free space on
<br>dev/hda5)<br><br><br>good luck,<br>pete<br><span class="ad"><br><br><br>__________________________________ <br>Yahoo! FareChase: Search multiple travel sites in one click.<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://farechase.yahoo.com/" target="_blank">
http://farechase.yahoo.com</a><br>_______________________________________________<br>mythtv-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:mythtv-users@mythtv.org" target="_blank">
mythtv-users@mythtv.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
</a><br></span></blockquote><span class="ad">
<div><br> </div>
<p>
<hr size="1">
<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://us.lrd.yahoo.com/_ylc=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2ODgxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a//farechase.yahoo.com/" target="_blank">
Yahoo! FareChase - Search multiple travel sites in one click.</a>
<p></p></p></span><br>_______________________________________________<br>mythtv-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br><br><br></blockquote>
</div>
<div><br> </div>
<div>sounds like mysql binary logs might be full. Stop myth. Backup mythconverg to another partition as suggested. Then log into the mysql client and run "reset master;" to clear your binary logs. Understand that you may also have to repair some tables. If mysql takes a long time to process the reset you may have to try clearing a small amount of space on the partition first. This is of course assuming that mysql is running on hda2. mythtv-setup or even the information page on the frontend should tell you where recordings are being stored.
<br clear="all"><br>-- <br>Thanks,<br>Devan Lippman <devan at lippman dot net> </div>