[wonslung]

I have a very large tv collect and a decent sized movie collection. I have my tv stuff on one server and my movie stuff on another. Currently, i'm using libnfs mounts for my sources. This works ok, but i'm noticing performance problems, especially with extremely large hd movies. Its almost impossible to change chapters, and ff doesn't work at all.


I get much better performance by mounting the nfs shares via fstab. I'm wondering how i can preserve my database (watched/unwatched, rating, etc)

Is there an easy way to do this?

[wsnipex]

you could export the DB, then sed/search replace the path in the export file and reimport it.
Or you do some update sql on the DB directly

[wonslung]

so let's say my path was setup like: nfs://192.168.1.14/tank/nas/Video/HD.Movies/

and i wanted to mount nfs at /mnt/movies/

I'd do something like:

Code:

update path set strPath = replace(strPath,'nfs://192.168.1.14/tank/nas/Video/HD.Movies/','/mnt/movies/');

??

[jmarshall]

Something like that, yeah. If you have rar or zip'd movies there might be another couple steps perhaps.

[wonslung]

it seemed to work well.