Reply to thread

Message

<blockquote data-quote="Deda" data-source="post: 674850" data-attributes="member: 89768">Changing drive letter in the database should be relatively easy. For quick replace it's better to do with some SQL lite database manager. I'm using sqlite-manager add-on for firefox (strange place but it's wonderful little addon). You can found it here: <a href="http://code.google.com/p/sqlite-manager/" target="_blank">sqlite-manager - Project Hosting on Google Code</a>.Open your VideoDatabaseV5.db3 file and search for path table, select it and click Browse&amp; Search (if table is not opened automatically). On the right screen you will se some table entries and you will recognize easy what they are. Select row where is your previous path with wrong drive letter, press Edit (or double click) and just replace wrong drive letter with new one.Same in VIdeoThumbBlist.Or you can use SQL script (click execute SQL tab and write script in Enter SQL text box)[code]UPDATE path SET strPath = REPLACE(strPath, 'OldDriveLetter:\', 'NewDriveLetter:\')and (if entries exists in VideoThumbBlist)UPDATE VideoThumbBlist SET strPath = REPLACE(strPath, 'OldDriveLetter:\', 'NewDriveLetter:\')[/code]Be sure that new drive letter is in MP Configuration/Video folders.That should be it (I never done that before but should work) and don't forget to backup your VideoDatabaseV5.db3 file before doing this.</blockquote>

[QUOTE="Deda, post: 674850, member: 89768"] Changing drive letter in the database should be relatively easy. For quick replace it's better to do with some SQL lite database manager. I'm using sqlite-manager add-on for firefox (strange place but it's wonderful little addon). You can found it here: [URL="http://code.google.com/p/sqlite-manager/"]sqlite-manager - Project Hosting on Google Code[/URL]. Open your VideoDatabaseV5.db3 file and search for path table, select it and click Browse& Search (if table is not opened automatically). On the right screen you will se some table entries and you will recognize easy what they are. Select row where is your previous path with wrong drive letter, press Edit (or double click) and just replace wrong drive letter with new one. Same in VIdeoThumbBlist. Or you can use SQL script (click execute SQL tab and write script in Enter SQL text box) [code] UPDATE path SET strPath = REPLACE(strPath, 'OldDriveLetter:\', 'NewDriveLetter:\') and (if entries exists in VideoThumbBlist) UPDATE VideoThumbBlist SET strPath = REPLACE(strPath, 'OldDriveLetter:\', 'NewDriveLetter:\') [/code]Be sure that new drive letter is in MP Configuration/Video folders. That should be it (I never done that before but should work) and don't forget to backup your VideoDatabaseV5.db3 file before doing this. [/QUOTE]

Verification