<div dir="ltr">Restoring only the useful parts of a database<br><br>I had a mythbuntu system that would often give "recorder failed" and<br>litter the media library with 4 identical entries of the failed<br>recording, each with "this file cannot be found" if you selected it,<br>
which were a pain to delete. Since I was not able to fix the issue, I<br>decided to reinstall everything from zero on a new hard disk. I did<br>take a backup of the database before reinstalling.<br><br>I would now like to restore the old recordings (the ones that work)<br>
and their metadata. In particular what I'd like is, for each .mpg, its<br>name, description and the manually-entered cut list that defines the<br>ads to be skipped. I don't terribly mind losing the date that the<br>
shows were recorded or the channel they came from, but I would very<br>much mind losing the cut lists and of course the film names, which I<br>understand would happen if I just copied the mpgs into the video<br>directory.<br>
<br>However I don't really want to restore all of the old database which<br>is full of that junk (empty entriesfor orphaned recordings<br>that never happened). I am also suspicious that the <br>faulty behaviour of the old system was perhaps due to<br>
slightly incorrect backend configuration (channels, capture cards,<br>video sources, input connections etc) that might be stored in the<br>database as well; I don't want to overwrite the new ones of the<br>reinstalled system that finally work with the old ones that didn't.<br>
<br>I have read<br><a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Change_the_hostname_of_a_MythTV_frontend_or_backend">http://www.mythtv.org/wiki/Database_Backup_and_Restore#Change_the_hostname_of_a_MythTV_frontend_or_backend</a><br>
and noticed their insistence on how bad a partial restore is, and that a<br>full restore is what every sane person should do. However I fear that<br>if I do a full restore I'll end up with as broken a system as the one I had<br>
before reinstalling.<br><br>I would simply like to restore the names and cut lists of the .mpgs<br>that I have. Nothing else. Can I? What should I do? Is it OK to take the database dump and, before importing it, delete everything except the statements for the tables that contain the names and cut lists?<br>
<br><br></div>