Results 1 to 10 of 12

Thread: How to maintain metadata when moving data files

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Question How to maintain metadata when moving data files

    I need to move a couple TBs of movies/music from the HDs they are on over to other HDs and a NAS. Does anyone know how I can maintain the metadata that I've already entered in Mezzmo (genre, year, cover art, etc?) I've already had to redo all of that once when I went from the trial to paid version. I'm not looking forward to doing it again and possibly multiple times in the future as I need to move data around.

    Thanks for the help,
    Marc

  2. #2
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,642

    Default

    Are you just changing the drive letter or the folder structure as well?

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  3. #3

    Default

    Drive letters definitely. The folder structure that contains the files will remain the same, but above that may change. IE: 'c:\users\%username%\videos\tv' becomes 'h:\videos\tv' and 'e:\movies' becomes 'h:\videos\movies'. But '..\tv\west wing\season x' remains the same.

  4. #4
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,642

    Default

    The only way to do this is to manually change the database's records - if you're comfortable with that, I can tell you what program to download and what SQL commands to enter to achieve this.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  5. #5

    Default

    Yes, I can do that. I've worked with sqlite and mysql a bit, so with your guidance I'm sure I can do that.
    Thank you..

  6. #6
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,642

    Default

    Ok, first step is to make a backup of your Mezzmo.db and of course stop the server, shut down Mezzmo.

    Then download the sqlite3.exe command line tool from here: http://sqlite.org/download.html (the precompiled binary for Windows).

    After that copy it to the same folder as Mezzmo.db and run:

    Code:
    sqlite3 mezzmo.db
    this should give you a database prompt. There enter:

    Code:
    update mgofile set file=replace(file,"C:\Users\blah\Videos\","H:\Videos\") where file like "C:\Users\blah\Videos\%";
    Please make sure that the second parameter in the replace() function is exactly as it's in the database, because this function is case-sensitive.

    Let me know how that goes.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •