View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 13 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sun Sep 09, 2007 10:56 pm 
Offline
Joined: Mon Feb 20, 2006 10:56 pm
Posts: 9
Location: Louisville, KY
Long story short, I would like to move recordings from one myth installation to another and need some help.

I have R5a26(myth A) on a drive that I would like wipe and integrate into my r5c7(myth B)install. However there are a number of recordings that I would like to selectively move over to the r5c7 install before I wipe the drive.

After reading the following forum posts:
http://mysettopbox.tv/phpBB2/viewtopic.php?t=13329&highlight=merge+databases
http://www.mysettopbox.tv/phpBB2/viewtopic.php?t=10195&highlight=merge+database

I have a better idea of what needs to be done however I am still unclear on many steps.

Since I am not going to be doing a new install do I just need to move the nuv files and sym links over while preserving ownership and permissions?

Also I am not sure I follow the SQL myphpadmin part. I thought I had better ask for some help after reading the warning:
Quote:
IF YOU ARE NOT SURE HOW TO USE PHPMYADMIN OR MYSQL DON'T DO THIS !!!


Thanks


Top
 Profile  
 
 Post subject:
PostPosted: Sun Sep 09, 2007 11:41 pm 
Offline
Site Admin
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location: Whittier, Ca
Read the MythTV docs.... This is covered.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 10, 2007 6:15 pm 
Offline
Joined: Tue Mar 22, 2005 9:18 pm
Posts: 1422
Location: Brisbane, Queensland, Australia
The other option would be to copy the files out of the Pretty directory and then put them into the Video directory of your other box.

_________________
Girkers


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 11, 2007 4:46 pm 
Offline
Joined: Mon Feb 20, 2006 10:56 pm
Posts: 9
Location: Louisville, KY
Thank you both for your contributions and taking time to reply.

Yesterday I may have done this completely wrong, so don't do this unless it has been blessed by someone who knows more about this than me, but so far it looks like things worked.

Backed up both old and new databases with mythbackup

I moved the contents of the pretty and tv folders:
Code:
cp -a /mnt/old/pretty/* /myth/pretty

Code:
cp -a /mnt/old/tv/* /myth/tv


Then, I followed the instructions from the mythtv docs under section 23.7 http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7
While it looked like all the old recording info made it, there were no previews for the old recordings nor could I watch them. Did a google and noticed something about blank basenames. Sure enough the old recordings had blank values in the recorded table's basename column. I don't know if I missed something or if this was just a result of moving nuv files in the format of chanid_startime_endtime.nuv ie 1046_20060123113000_20060123120000.nuv to my current version which uses chanid_startime.mpg

I ran the following update:
Code:
 UPDATE recorded SET basename = CONCAT(chanid, '_', DATE_FORMAT(starttime,'%Y%m%d%H%i00'),'.mpg') where basename = '';

Then truncated the filenames and changed .nuv to .mpg in /myth/tv folder. ie 1046_20060123113000.mpg. There is probably a real slick way to rename these in one line with regex but I did them by hand.

I still have the old myth install intact and I have backups of the databases in case I really fubared this.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 11, 2007 8:07 pm 
Offline
Joined: Tue Mar 22, 2005 9:18 pm
Posts: 1422
Location: Brisbane, Queensland, Australia
For reference the Pretty folder is simply symlinks to the TV folder with easy to read names.

_________________
Girkers


Top
 Profile  
 
 Post subject: what is the trick?
PostPosted: Tue Sep 11, 2007 8:34 pm 
Offline
Joined: Tue Mar 28, 2006 8:26 pm
Posts: 804
Location: Minneapolis, MN
Girkers wrote:
The other option would be to copy the files out of the Pretty directory and then put them into the Video directory of your other box.

Girkers, What is the trick to copying the symlinks in the PRETTY folder and getting the actual files they point at to come along during the copy process?

You see, I've tried to copy items from the PRETTY folder from both a Knoppmyth command line and using the Linux xfe graphic file browser loaded on the Knoppmyth machine and all I ended up copying were the simlinks - no video files.

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner


Top
 Profile  
 
 Post subject: Re: what is the trick?
PostPosted: Tue Sep 11, 2007 11:06 pm 
Offline
Joined: Sun Aug 28, 2005 7:07 pm
Posts: 821
Location: Melbourne, Australia
neutron68 wrote:
Girkers, What is the trick to copying the symlinks in the PRETTY folder and getting the actual files they point at to come along during the copy process?


Hi Eric,

The /myth/pretty symlinks are generated every 15 minutes (I think) as a cron job by matching up the file names with the real names in the database.

They are regenerated regardless of whether they already exist.

Mike

_________________
*********************
LinHES 7.4
Australian Dragon
*********************


Top
 Profile  
 
 Post subject: Re: what is the trick?
PostPosted: Wed Sep 12, 2007 9:03 am 
Offline
Joined: Tue Mar 28, 2006 8:26 pm
Posts: 804
Location: Minneapolis, MN
manicmike wrote:
Hi Eric,

The /myth/pretty symlinks are generated every 15 minutes (I think) as a cron job by matching up the file names with the real names in the database.

They are regenerated regardless of whether they already exist.

Mike

Yep. I am familiar with how the symlinks get in the PRETTY folder, but that wasn't my question.

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 12, 2007 9:23 am 
Offline
Joined: Thu Sep 07, 2006 11:20 am
Posts: 389
These links may be of interest:

http://www.mythtv.org/wiki/index.php/Up ... e_internet

http://www.mythtv.org/wiki/index.php/Nuvexport


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 12, 2007 6:21 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
The nuvexport utility has a mode specifically for this which dumps the SQL needed to import the file into another system.
http://www.mythtv.org/wiki/index.php/Nuvexport#Export_to_.nuv_and_.sql


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 12, 2007 10:32 pm 
Offline
Joined: Tue Mar 22, 2005 9:18 pm
Posts: 1422
Location: Brisbane, Queensland, Australia
Let me preface this by saying there are many ways of doing what you want to achieve. My suggestion is simply that, my suggestion.

Any way the reason your cp command didn't follow the symlinks is you specified the -a command. The cp man page states this:
Quote:
-a, --archive
Preserve as much as possible of the structure and attributes of the original files in the copy. Equivalent to --physical --preserve --recursive.
-p, --preserve
Preserve file owner, group, permissions and timestamps.
-P|d, --physical|nodereference
Don't follow symbolic links; copy symbolic rather than the files they point to.
-r|R, --recursive
Operate on the contents of directories recursively.

So when you specify -a one of the options you are specifying is -P which tells it not to follow symlinks.

To copy the file a symlink refers simply use the cp command and no options and you will be right to go.

_________________
Girkers


Top
 Profile  
 
 Post subject: thanks Girkers
PostPosted: Thu Sep 13, 2007 11:49 am 
Offline
Joined: Tue Mar 28, 2006 8:26 pm
Posts: 804
Location: Minneapolis, MN
Girkers wrote:
To copy the file a symlink refers simply use the cp command and no options and you will be right to go.

Thanks Girkers, that is exactly what I wanted to know. :)

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner


Top
 Profile  
 
 Post subject:
PostPosted: Thu Sep 13, 2007 9:24 pm 
Offline
Joined: Mon Feb 20, 2006 10:56 pm
Posts: 9
Location: Louisville, KY
Thanks everyone. :D


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu