Moving records from windows to linux

[flyingsubs]

So I'm trying to migrate from my windows instance to windows.

I see when I record using NPVR on the linux backend the recordings show up.  Is there anyway I can move my existing recordings from my windows box to my linux media folder and have NPVR see them? 

Thanks!
Flyingsubs

[mvallevand]

Here is an example sqlite script that will copy the resume position, the deleted files (for avoid duplicates) and the recordings showing some of the cases you need to deal with for changing the mount point.

Code:

.open npvr.db3
attach '/v4/npvr.db3' as v4;
.databases

insert into recently_deleted select * from v4.recently_deleted where v4.recently_deleted.oid not in (select oid from recently_deleted);

insert into playback_position select * from v4.playback_position;

insert into scheduled_recording select * from v4.scheduled_recording where v4.scheduled_recording.oid not in (select oid from scheduled_recording);

update scheduled_recording
set filename = replace(filename,"\","/");

update scheduled_recording
set filename = replace(filename,"C:/movies/","/media/vista/");

update scheduled_recording
set filename = replace(filename,"C:/LiveTV/","/buffer/");

update scheduled_recording
set filename = replace(filename,"K:/","/recordings/");

update scheduled_recording
set filename = replace(filename,"k:/","/recordings/");

update scheduled_recording
set filename = replace(filename,"//172.16.3.244/Movies","/movies/");

Martin

[flyingsubs]

Oh that makes sense that the information is in the the database.  I'm assuming I need to copy over my V4 database to my Raspberry pi and then run through the steps below updating the location of my media folder and referencing the new database in V5?

-Flyingsubs

[mvallevand]

Don't overwrite the v5 database, the v4 npvr.db3 file can be with your recordings which I am assuming will be on share.

Martin

[flyingsubs]

I manually moved all my recordings to /media/recordings. I haven't set up a share since I am planning on decommissioning my windows machine assuming I can run everything on my Raspberry Pi. I have heard you don't want to override the DB.

I think I understand the code you have except for this section. All the update scheduled recordings. Are these all the different file locations for your media?

update scheduled_recording
set filename = replace(filename,"C:/movies/","/media/vista/");

[mvallevand]

I just created some examples showing how someone might want to do conversion, you can use drive letters, folders, shares etc depending what the new base is going to be. In my case I do have media all over the place.

Martin

[flyingsubs]

Thanks! Much appreciated. Going to try this out.

[flyingsubs]

So I took your idea and tried Sudo and that got me a bit further. This time it's saying the database is locked, I tried stopping NPVR and making sure nothing is being recorded or streamed. Is there a process that needs to be stopped in order to free up the database?

[mvallevand]

So I took your idea and tried Sudo and that got me a bit further. This time it's saying the database is locked, I tried stopping NPVR and making sure nothing is being recorded or streamed.  Is there a process that needs to be stopped in order to free up the database?

I never update a database while the servicr is running it should work fine if you stop the it assuming you have the filenames right.  You can try copying it somewhere to confirm

Martin

[flyingsubs]

I'm pretty sure I have the databases correct. I did a test with this statement and it returned results.

select * from v4.recently_deleted where v4.recently_deleted.oid

I stop NPVR with :
sudo service nextpvr-server stop

Are there any services that I need to stop? I can't seem to figure out what is causing the database to be locked. Any ideas?

Thanks!
Flyingsubs