ok Kippi here you go i posted a message about this some time ago on the support forums.
link to the forums is here but follow the steps i put below the link. It should be easier to follow FORUM LINK http://support.spacialaudio.com/forums/viewtopic.php?f=20&t=25758&start=15 Here is the end result of what i did that worked: 1) Download MYSQL GUI tools from here: http://dev.mysql.com/downloads/gui-tools/5.0.html run after you install it run "mysql query browser". 2) Connect to the samdb 3) Paste this code: EXAMPLE \\\\\\\\ update songlist set filename = replace(filename, 'letter for old drive:', 'letter for new drive:') /////////// ------------- Ok try that out but PLEASE keep a secondary backup of your SAM DATABASE ------------- other thing i tried which took longer was changing the REST of the path aside from just changing the DRIVE letter use the command prompt i posted above, then open your SAM DB Backup in WORDPAD ( if using windows PC ) the file you want to open is "songlist.MYD" hit CONTROL+F this will open the FIND /REPLACE function type in what path you want to find " new drive letter\path folder\path folder\" change tp " new drive letter\NEW path folder\maybe something else\ another new path folder\" then hit REPLACE ALL depending on the size of the file, youll have to just let it run on its own for a couple mins at most walk away, get a drink, love your woman a bit, then come back. Open SAM on the new machine and IMPORT the newly edited database FOR THE LOVE OF GOD!!! MAKE SURE YOU STILL HAVE THAT SECONDARY BACKUP OF YOUR SAM DB ----- Original Message ----- From: "Kipp Gremillion" <[email protected]> To: <[email protected]> Sent: Saturday, July 18, 2009 10:00 PM Subject: [General-discussion] Moving SAM to another server >I need to move SAM to another server. I wish to move it as is DB, music >and > all with only one change. I will need to change the the paths to the > songs > during the move. I figure I am not the first to do this and there must be > some info on this. Any suggestions/comments? > > Thanks > _______________________________________________ > General-discussion mailing list > [email protected] > http://mailman.spacialaudio.com/mailman/listinfo/general-discussion > > TO unsubscribe to this list, simply send a blank email to > [email protected] > > with the subject > 'unsubscribe'
