Moving NextPVR to new system (linux)

[mvallevand]

Did you follow the steps on the wiki to create the softlinks?

Martin

[cyber]

Yes I have, I wasn't quite sure where to run it, I ran both of these commands in /opt/nextpvr/system/

Code:

ln -s runtimes/linux-x64/native/libe_sqlite3.so
ln -s runtimes/linux-x64/native/libSkiaSharp.so

I can see a link to libe_sqlite3.so and libSkiaSharp.so in that folder.

I'm moving from RaspberryPi OS (32bit) to Debian (64bit - Intel) if that matters?

[mvallevand]

Sorry I messed up, I was supporting by phone and didn't read the message. Looking at the code the merge is for a different purpose. I wrote all of this with no user input and I messed up my uses cases.

Import will work, but for this, your best bet is a simple sqlite3 replace something like this (untested)

sqlite3 npv43.db3

update scheduled_recording set filename = replace(filename,'/mnt/MyPassport/', '/mnt/data/');

Martin

[cyber]

Is that 2 commands - enter one after another in the terminal?

sqlite3 npv43.db3

update scheduled_recording set  filename = replace(filename,'/mnt/MyPassport/', '/mnt/data/');

Should the first command be sqlite3 npvr.db3 rather than sqlite3 npv43.db3?

[mvallevand]

Use the sqlite3 command (with the correct db name of course) Also sudo -u nextpvr sqlite3 ...

Then the second command is entered on the sqlite3 command line.

Then .exit to leave.

Martin

[cyber]

The sqlite3 command (sudo -u nextpvr sqlite3 npvr.db3 and the replace) doesn't seem to do anything when I enter it. The date modified on npvr.db3 remains unchanged.

I tried to start nextpvr as well, the links to download any recordings are broken so it hasn't updated them.

[mvallevand]

When you are in sqlite3 when you enter this

select filename from scheduled_recording;

do they begin with /mnt/MyPassport

Martin

[cyber]

Thanks, I realised I had a typo in the path which was causing the issue.

For reference if anyone else wants to do this, here's a short guide with the steps I followed assuming the old recordings path is '/old/path/to/recordings/' and the new path is '/new/path/to/recordings/'. Remember to backup files before touching them. (I'm fairly inexperienced at linux so there may be better ways to do some of these!)

Code:

On both the old and new systems:
sudo service nextpvr-server stop (Stops nextpvr)
sudo service nextpvr-server status (Optional but to check if the service has stopped)

On the old system:

sudo rsync -rav /old/path/to/recordings/ /external/usb/drive/recordings/ (copies recordings to USB drive/recordings)
cd /var/opt/nextpvr/
sudo rsync -rav npvr.db3 /external/usb/drive/ (copies npvr3.db3 to USB drive)
sudo rsync -rav config.xml /external/usb/drive/ (copies config.xml to USB drive)

Plug the external USB drive into the new system.

On the new system (I had permissions issues on transferring config and npvr.db3 so edited them on the desktop):

sudo rsync -rav /external/usb/drive/recordings/ /new/path/to/recordings/ (copies recordings to new location)
sudo rsync -rav /external/usb/drive/config.xml ~/Desktop/ (copies config.xml to Desktop)
sudo rsync -rav /external/usb/drive/npvr.db3  ~/Desktop/ (copies npvr3.db3 to Desktop)


(edit config.xml on Desktop with the following)
nano ~/Desktop/config.xml
    <AutoRemoveMissingRecordings>false</AutoRemoveMissingRecordings>
    <CheckForRenamedRecordings>false</CheckForRenamedRecordings>
    <NoRemoveWhenTreeMissing>true</NoRemoveWhenTreeMissing>
    (Ctrl-x to exit and save)

sudo apt install sqlite3
sqlite3 ~/Desktop/npvr.db3
    (enter the following on the sqlite3 command line)
    update scheduled_recording set filename = replace(filename,'/old/path/to/recordings/', '/new/path/to/recordings/');
    .exit

(back on to the main terminal window)

sudo rm /var/opt/nextpvr/npvr.db3 /var/opt/nextpvr/config.xml (remove the default files on the system, I had no reason to back them up because it was a clean install but you may want to)
sudo mv ~/Desktop/npvr.db3 /var/opt/nextpvr/ (move npvr3.db3 to correct location)
sudo mv ~/Desktop/config.xml /var/opt/nextpvr/ (move config.xml to correct location)
cd /var/opt/nextpvr/
sudo chown nextpvr:nextpvr npvr.db3 config.xml (change user/group to nextpvr)
sudo service nextpvr-server start (to start nextpvr)

Thanks again for the help mvallevand