G'day,

I have deleted an original when I transcoded. The good thing is I still have the original NUV file backed up. How do I "restore" it so that I can use it in myth as a recorded file with the correct length etc, and then edit it and transcode ? Any ideas ?

Matt

G'day,

Sorry, just did a bit more digging and it appears that this just isn't possible. I might have to move the file to a windows box and deal with it there.

Matt

Why wouldn't it be possible? Use nuvexport to export a show w/ the SQL statement. Edit the SQL for your show, then import it back. Now that I've done this, but I see no reason why it wouldn't work. Unless that feature has been removed from nuvexport...

G'day,

Thanks for the reply. OK , I worked out what you meant by NUVexport. I ran it and it made a .sql file. I presume i need to edit that file and then do mysql < filename.sql.

My problem now, is that I'm not sure what to edit out of the table so that I can rejig the cutpoints etc.

I have a bit that goes something like

USE mythconverg;

INSERT INTO recorded (findid, programid, recgroup, hostname, previouslyshown, lastmodified, cutlist, commflagged, starttime, autoexpire, editing, preserve, endtime, category, deletepending, originalairdate, stars, chanid, description, filesize, subtitle, bookmark, recordid, title, seriesid) VALUES
('0', '', 'Default', 'mythtv', '0', '20051012160934', NULL, '1', '2005-10-02 19:08:00', '1', '0', '0', '2005-10-02 19:09:00', '', '0', '2005-10-02', '0', '1034', '', '4666364213', 'Sun Oct 2 19:05:00 2005', NULL, '13', 'NRL Grand Final (Manual Record)', '');

;

INSERT INTO recordedmarkup (mark, starttime, type, chanid, offset) VALUES
('0', '2005-10-02 19:08:00', '-3', '1034', NULL),
('0', '2005-10-02 19:08:00', '9', '1034', '0'),
('13', '2005-10-02 19:08:00', '9', '1034', '442156'),
('25', '2005-10-02 19:08:00', '9', '1034', '890936'),
('37', '2005-10-02 19:08:00', '9', '1034', '1340111'),
('49', '2005-10-02 19:08:00', '9', '1034', '1789820');

I was thinking maybe I just delete everything after 0') ???

Matt

Why not import it as is and manually edit the cutlist once you have it in Myth?

_________________
cesman

When the source is open, the possibilities are endless!

All those numbers in the recordedmarkup table map frame numbers to byte offsets in the nuv file. These will be different for different recordings and seeking and commercial cutting will not work properly unless that data is correct. nigelpearson has made some posts about using mythcommflag --rebuild to rebuild the recordedmarkup data. Previously, it didn't work for mpeg2 files however he reports that it does work now. I have not tried it.

You should edit the data in the "insert into recorded" query and then run the query. This is done something like

Then run the mythcommflag --rebuild on that file.

If all you're looking to do is have the recording available for future viewing, and don't care that it doesn't show up in the "recordings" list, you could take this simpler approach:

Convert to avi via nuv2avi
Copy the avi to /myth/video

The program in question now will show up as an entry in MythVideo.

_________________
R5Fxx

Home-Brewed Mythic Dragon Clone
200GB WD IDE /myth
2x250GB WD IDE (lvm) /myth/tv

G'day,

Thanks for the replies, I think I have enough info to go a little further, I will report back how I go. BSHroyer, I want it in the recordings list because I need to edit it and blow it to DVD.

Thanks

You are in luck. Since you have the critical DB record you can restore the file and actually have it work again. DO NOT jigger the SQL! There is critical infomation in there which you simply can't get back by any means I was able to discover. Do as Cecil suggests and restore it as is, then fuss with the markup from inside MythTV.

G'day,

What do I need to do within myth then ? Is there somewhere to "reinitialise" the clip and dump all of the cutpoints etc ?

Matt

There are more detailed instreuctions in an old posting around here somewhere but you just put the .nuv file in the right place (/myth/tv) and feed the .sql file to mysql to be run... As root:

G'day

Well, I successfully dragged the file back into Myth but somehow when I go to edit it, myth thinks it is 1 second long ! Obviously something isn't right. So now I think I will export it and burn it / edit it on windoze.

So I ran nuvexport with the DVD option and I get a problem where it can't get fifos and then exits. When I just take the nuv directly to windoze, I can play it in WMP etc, but virtual dub etc won't recognise it. Any suggestions. Sorry to be a pain, but I am really keen to blow this to a dvd before I kill it.

Matt