<br><div class="gmail_quote">On Mon, Feb 25, 2008 at 11:11 AM, Chuck Peters <<a href="mailto:cp@ccil.org">cp@ccil.org</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Here is what happened on my dryrun attempt:<br>
cp@peters:/tmp$ perl ./myth.find_orphans.pl --dryrun<br>
--dbhost=<a href="http://192.168.2.1" target="_blank">192.168.2.1</a> --host=<a href="http://192.168.2.1" target="_blank">192.168.2.1</a> --pass=password<br>
DBD::mysql::st execute failed: Table 'mythconverg.storagegroup'<br>
doesn't exist at ./myth.find_orphans.pl line 277.<br>
Could not execute () at ./myth.find_orphans.pl line 277.</blockquote><div><br>Not that my perl skills are worth a damn I started looking at the code and noticed using the --dir option would skip looking up the directory in the storage groups table.<br>
<br>This seems to be more productive:<br>cp@peters:/tmp$ perl ./myth.find_orphans.pl --dryrun --dbhost=<a href="http://192.168.2.1">192.168.2.1</a> --host=peters --pass=password --dir=/lvm/home/mythtv/store<br>Long file list abbreviated...<br>
Missing media: 1054_20061211210000.nuv (title:Engineering an Empire, start:2006-12-11 21:00:00)<br>Missing media: 1054_20061214200000.nuv (title:Engineering an Empire, start:2006-12-14 20:00:00)<br>unknown file [136B]: /lvm/home/mythtv/store/1003_20070325190000.mpg.png<br>
unknown file [14.0KB]: /lvm/home/mythtv/store/1035_20070219010000.nuv.png<br>Summary:<br> Host: peters, Directories: /lvm/home/mythtv/store<br> 840 valid recordings, 282 missing recordings not fixed, check above is valid and use --dodbdelete to fix<br>
1680 known media files using 795.0GB<br> 304 orphaned thumbnails with no corresponding recording<br> 1 unknown files using 146.9MB not fixed, check above and use --dodelete to clean up if the above output is accurate<br>
<br>And that number of 282 missing recordings does correspond to another list I have from before the disk crash.<br><br> <br>Thanks,<br>Chuck<br></div></div><br>