Movie migration to NAS by editing SQL database

Discussion in 'Moving Pictures' started by lauzon, December 15, 2014.

  1. lauzon

    lauzon Portal Member

    Joined:
    December 7, 2008
    Messages:
    12
    Likes Received:
    0
    Ratings:
    +0 / 0
    Home Country:
    Germany Germany
    I am trying to move all my movies to my NAS by editing the SQL database file.
    I changed following fields:

    Local Media: Full path (UNC), Import path ID, Media Label (cleared), Volume Serial (cleared)
    Import Path: Path (UNC)

    This approach worked perfectly when I moved all movies from external harddrives to my local raid, some time ago. No rescanning occurred. This time, all movies get rescanned and I would have to manually match and edit just much too many of them again.



    Do I have to alter some more fields in the database? Someone has an idea?
    Cheers

    P.S. Moving pictures is amazing!

    Moving Pictures 1.8.0.1607
    MediaPortal 1.8.0
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. InTranceWeTrust

    InTranceWeTrust Portal Member

    Joined:
    October 22, 2010
    Messages:
    15
    Likes Received:
    3
    Ratings:
    +3 / 0
    Home Country:
    Greece Greece
    Show System Specs
    i did that a year ago, if i remember correctly i used

    UPDATE criteria SET value = REPLACE(value, 'oldRoot','newRoot');
     
  4. lauzon

    lauzon Portal Member

    Joined:
    December 7, 2008
    Messages:
    12
    Likes Received:
    0
    Ratings:
    +0 / 0
    Home Country:
    Germany Germany
    This is exactly how I changed all the fields I mentioned in my previous post. Problem is, it seems only to work with changing drive letters/hd paths. When I change it to a network path, moving pictures rescans the movies.

    There must be a field, that I have to change additionally. I can not find it.
     
  5. RoChess
    • Premium Supporter

    RoChess Extension Developer

    Joined:
    March 10, 2006
    Messages:
    4,182
    Likes Received:
    1,304
    Ratings:
    +1,683 / 2
    HDD paths get volume info stored, which does not work on UNC paths. Perhaps look there?

    If you had just added the new path/drive as new import path, then moved all the files over, then MovPic would have auto-updated all the path references automatic without any SQLite editing required. Once all is moved over you can delete the old import path.
     
  6. lauzon

    lauzon Portal Member

    Joined:
    December 7, 2008
    Messages:
    12
    Likes Received:
    0
    Ratings:
    +0 / 0
    Home Country:
    Germany Germany
    I did try that, problem is, it does not seem to work with the DVD folder structure. When moving data like mkv files, everything is fine - no rescanning. But all my DVDs (800+), they get rescanned - my guess is because there is no FileHash for DVDs in the database. For this reason I came up with editing the database some time ago and it worked perfectly then, when only moving from local drive to local drive.

    Regarding your suggestion of the volume info: I imported a couple of movies regularly on the NAS, just to compare the fields in the database. And as you suggested, there is no volume serial stored. Also the "Media Label" field is empty, that is why I cleared them both. These are my altered fields:
    Local Media: Full path (UNC), Import path (ID), Media Label (cleared), Volume Serial (cleared)
    Import Path: Path (UNC)

    There must be a field that I am missing! I can not find it!

    EDIT: Just found out that only movies without the File Hash have (understandably) the problem. Strangely nearly all of my movies with a DVD/Blu Ray folder structure, are missing the File Hash. All movies with File Hash are moved in the database correctly.

    Does somebody know if there is a way of recreating the File Hash?
     
    Last edited: December 22, 2014
  7. RoChess
    • Premium Supporter

    RoChess Extension Developer

    Joined:
    March 10, 2006
    Messages:
    4,182
    Likes Received:
    1,304
    Ratings:
    +1,683 / 2
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!