Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: How to maintain metadata when moving data files

  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,639

    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,639

    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,639

    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

  7. #7

    Default

    Worked like a charm, thank you. I used http://sqlitebrowser.sourceforge.net to see the exact paths which were already in the db in order to get the cases correct. After running the update command for all folders, I then opened Mezzmo and changed the folder locations for the folders I had added. Checked the metadata and it all appears to be there.

    Thank you for your help.
    Marc

  8. #8
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,639

    Default

    Glad to help and hopefully this will help others 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

  9. #9
    Join Date
    Apr 2010
    Posts
    18

    Default

    I successfully updated strings in mezzmo.MGOFile.file about a year ago, but now when I try the following query it returns "Error: column file is not unique":

    update MGOFile set file = replace(file, 'D:\', 'F:\') where file like 'D:\%';

    Tried double quotes, the mezzmo service is stopped and select * from mgofile where file like "D:\%"; confirms the existence of the string. All I need is to change the drive letter...
    Last edited by steppinwolf; 12-21-2011 at 01:50 PM.
    Windows 7 Pro x64; Mezzmo 2.4.5.0

  10. #10
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,639

    Default

    It needs double-quotes, but you tried that. Strange, it should work. Which database browser/editor are you using?

    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
  •