Souns great. Just make sure that your old sam is working perfectly. I don't want to see problems on a new install.
On Sun, Jul 19, 2009 at 5:02 PM, Kipp Gremillion <[email protected]>wrote: > Nice, thanks. > > And thanks to everyone else for the instructions. I plan on attempting it > this week with fingers crossed. > > Kipp > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > Antifmradio > Sent: Saturday, July 18, 2009 11:20 PM > To: [email protected] > Subject: Re: [General-discussion] Moving SAM to another server > > 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' > > _______________________________________________ > 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' > > > _______________________________________________ > 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' >
