[mythtv-users] Some lost recording due to Seagate 500GB crash

[Chuck Peters]

On Mon, Feb 25, 2008 at 11:11 AM, Chuck Peters <cp at ccil.org> wrote:

>
> Here is what happened on my dryrun attempt:
>  cp at peters:/tmp$ perl ./myth.find_orphans.pl --dryrun
> --dbhost=192.168.2.1 --host=192.168.2.1 --pass=password
> DBD::mysql::st execute failed: Table 'mythconverg.storagegroup'
> doesn't exist at ./myth.find_orphans.pl line 277.
> Could not execute () at ./myth.find_orphans.pl line 277.


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.

This seems to be more productive:
cp at peters:/tmp$ perl ./myth.find_orphans.pl --dryrun
--dbhost=192.168.2.1--host=peters --pass=password
--dir=/lvm/home/mythtv/store
Long file list abbreviated...
Missing media: 1054_20061211210000.nuv (title:Engineering an Empire,
start:2006-12-11 21:00:00)
Missing media: 1054_20061214200000.nuv (title:Engineering an Empire,
start:2006-12-14 20:00:00)
unknown file [136B]: /lvm/home/mythtv/store/1003_20070325190000.mpg.png
unknown file [14.0KB]: /lvm/home/mythtv/store/1035_20070219010000.nuv.png
Summary:
  Host: peters, Directories: /lvm/home/mythtv/store
  840 valid recordings, 282 missing recordings not fixed, check above is
valid and use --dodbdelete to fix
  1680 known media files using 795.0GB
  304 orphaned thumbnails with no corresponding recording
  1 unknown files using 146.9MB not fixed, check above and use --dodelete to
clean up if the above output is accurate

And that number of 282 missing recordings does correspond to another list I
have from before the disk crash.


Thanks,
Chuck
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080226/59a7c589/attachment.htm