[mythtv-users] Database corruption

[Stephen Worthington]

On Sun, 3 Oct 2021 11:46:05 +0800, you wrote:

>I added a movie, Allied.mp4, to videos, scanned and there is was not.
>
>I spelunked the DB and got this:
>
>
>(10347,'L\'allieva','',NULL,'Unknown','Rai 1','Alice Allevi is a student of undecided medicine on her own future. After the death of the minding one of her grandmother it discovers her road: the legal medicine. Frequenting the institute of legal medicine she comes upon in the charismatic and arrogant doctor Claudio Conforti, of which him infatua and with which a strong agreement is created. But she is also fascinated by the young, sincere and nice Arthur, child of the manager of her institute, while it is being to the takings in love as in the life with choices and binding situations','NR','ttvdb.py_316861',-1,'',2016,'2016-09-27',9,50,0,0,0,1,'Myth-A/Allied.mp4','38759a58e8f65a24','ttvdb.py_316861_coverart.jpg',-1,1,0,1,NULL,0,'','sandypit','','ttvdb.py_316861_banner.jpg','ttvdb.py_316861_fanart.jpg','2021-09-29 08:07:02','MOVIE'),
>
>(10348,'Terminator: Dark Fate','',NULL,'Unknown',NULL,'None','NR','00000000',-1,'',1895,'0000-00-00',0,0,0,0,0,1,'Myth-T/Terminator: Dark Fate.mp4','c70b079479259a09','TerminatorDarkFate.jpg',0,1,0,1,NULL,0,'','sandypit','','','','2021-09-29 08:07:02','MOVIE’)
>
>Clearly the DB is broken.
>I’d rather NOT scan an empty DB and rebuild the meta data (an awefull task)
>
>Do the mysql gods think I can restore a DB with the corrupted section removed, rescan and recover?
>
>Thanks
>James

I am not sure what you are seeing here that indicates database
corruption.  Just having a video file not scan into the database does
not necessarily indicate corruption.  Video files have the start of
the file hashed by the scanning process, and if that hash happens to
match an existing hash on another file, it thinks they are the same
file.  I have always thought the hash should include the file name and
size to help prevent this sort of thing, but I do not remember that
being done.