Say that you put your wedding ring in a silver box, inside of a black box inside of a gray box inside of an orange box.
So now you know you just have to find the orange box and then inside will be a gray box, with a black box and a silver box, inside there is your wedding ring. Now, say I come along and and remove the orange box and in its place put a green box. Now you cannot find your ring cause your looking for an orange box. This is exactly what is happening with SAM. You need to calm down, take a breather and read the instructions you were given, the CD your typing is is a command, it means Change Directory. You type in: cd c:\ (enter) And it will change the directory to the C directory. When changing your music location it can be easy to solve but it does take patience. James Henline. Help Desk Manager Development Manager Spacial Audio Solutions LLC. 972-739-6420 ext: 110 www.audiorealm.com www.spacialnet.com www.spacialaudio.com CONFIDENTIALITY NOTICE: This email, including any attachments, contains information from SpacialAudio Solutions LLC., which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this email in error, please notify the sender immediately by "reply to sender only" message and destroy all electronic and hard copies of the communication, including attachments. On Sat, Nov 1, 2008 at 11:46 PM, Antifmradio <[email protected]> wrote: > youve got to be kidding. > > i just tried that process and i got to > " 1st command " > cd \ > > i typed that in and nothing. i just drops me down to the next line and iwth > C:> in the begining > > i was able however to get a mysqldump HELP list but thats just completely > insane the amount of information in need to look through > line by line. > I just wanted to change a drive location its looking for. > > NONE of the php or installation files for SAM are located on this new drive. > The only thing on the new drive is the audio files that i put in > None of the audio files that come with SAM are on the new drive. they are on > the computers hard drive > and that is NOT changing > > > > ----- Original Message ----- From: "dstjohn" <[email protected]> > To: "Antifmradio" <[email protected]> > Sent: Saturday, November 01, 2008 11:30 PM > Subject: Re: [General-discussion] How to change DRIVE location in SAM > > >> Use sql maestro for mysql, you can do dumps visualy with there tools. >> >> command line go to the bin directory of where ever mysql installed and you >> will see a commnad line tool >> in there called mysqldump >> just start up a command prompt and cd to that directory. >> example >> >> start -> run -> cmd >> 1st command >> cd \ >> 2nd command >> cd C:\path\to\mysql\bin >> 3rd command >> mysqldump --help or mysqldump /? >> >> the 3rd command will reveal all options >> 4th command >> mysqldump --user=root --password=123456 --opts --databases=SAMDB > >> C:\SAMDB-bak.sql >> i could be wrong on the flag --databases, it could be singular --database >> >> then to reimport the dumped file thats been changed after you notepad it >> and change the paths >> from that same directory with the command line >> mysql --user=root --password=123456 < C:\SAMDB-bak.sql >> >> viola should be all done. >> >> >> Hope that helps. >> >> >> Antifmradio wrote: >>> >>> ok now heres a good question >>> how do a MYSQL dump of the SAM DB? >>> >>> i was just looking in the MySQL Administtrator and i dont see it there. >>> While im waiting for the reply,, ill poke around SAM to see >>> >>> ----- Original Message ----- From: "dave st john" >>> <[email protected]> >>> To: "AntiFMRadio.com" <[email protected]>; >>> <[email protected]> >>> Sent: Friday, October 24, 2008 12:55 PM >>> Subject: Re: [General-discussion] How to change DRIVE location in SAM >>> >>> >>>> Actualy its alot easier then it sounds. >>>> Do a mysql dump on the sam db, open it notepad. >>>> >>>> then just do a simple search and replace >>>> example >>>> >>>> ctrl + H in notepad >>>> >>>> Find what: F:\all audio >>>> Replace with: D:\new audio >>>> >>>> the click replace all, save file and reimport. >>>> >>>> If the dump makes notepad burp, use wordpad. >>>> >>>> If your sam mysql db is on a linux machine to the following. >>>> >>>> mysqldump -h localhost -u root -p --opt --databases SAMDB > samdb.sql >>>> >>>> then use sed to search and replace >>>> >>>> sed 's/D\:\\All Audio/F\:\\New Audio/' /path/to/samdb.sql > >>>> new.samdb.sql >>>> >>>> You may need to work out the escape \ on the : and \ characters in that >>>> command, as sed is sensative to regexp, thats just an example of how to to >>>> that on a mass scale. >>>> >>>> then you would just reimport with a command like this on linux >>>> mysql -u root -p < new.samdb.sql >>>> >>>> >>>> >>>> Hope that helps and gives you some ideas on how to fix that. >>>> Your initial idea is on the right track, but this procedure takes care >>>> of it at the core storage area. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> AntiFMRadio.com wrote: >>>>> >>>>> Its been said before by doing an SQL command that i can change the >>>>> Drive location SAM will look for all files. >>>>> >>>>> This is related to ONLY my music files so i have a couple questions. >>>>> >>>>> Im getting a new external drive and want to dump all my existing music >>>>> files onto it >>>>> But i want to make sure SAM will start looking in THAT location instead >>>>> if me going to EACH file and changing it in SONG INFO. >>>>> This would otherwise take weeks as there are currently more then 2000 >>>>> files so >>>>> >>>>> 1) What is the command promt steps to change an audio file location in >>>>> SAM from Drive letter "x" to Drive letter " New X" >>>>> >>>>> 2) Would this process work as well?::: >>>>> a) Goto my MUSIC ALL category in SAM >>>>> b) Save that listing as a PLAYLIST file ( pls.) >>>>> c) Open the lps file in a text editor >>>>> d) Use the FIND & REPLACE function to change all drive locations to the >>>>> correct one >>>>> e) Remove the files from my current MUSIC ALL >>>>> f) Add the pls file to my MUSIC ALL category ( now that it has the new >>>>> drive location saved in the text of it ) >>>>> >>>>> If this a,b,c, steps works, then i can also do this for the other Music >>>>> Categories i have created. >>>>> >>>>> Has anyone tried that? >>>>> _______________________________________________ >>>>> 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' >>> >>> >> >> -- >> This message has been scanned for viruses and >> dangerous content by MailScanner, and is >> believed to be clean. >> > > _______________________________________________ > 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' > From [email protected] Sun Nov 2 10:25:31 2008 From: [email protected] (Dave St John) Date: Sun Nov 2 11:41:34 2008 Subject: [General-discussion] How to change DRIVE location in SAM In-Reply-To: <[email protected]> References: <20070124081407.kquj27073.centrmmtai08.cox....@centrmimpi02.cox.net> <[email protected]> <002701c935f4$744f0d80$2402a...@espxp1> <[email protected]> <001a01c93c8c$9cb16810$6901a...@acer5100> <[email protected]> <002f01c93c9d$a67de3d0$6901a...@acer5100> <[email protected]> Message-ID: <[email protected]> You can do a dump of the mysqldump --help information by doing this command. 1st command (after you change directory to the mysql bin directory of course) mysqldump --help > C:\mysqldump-help.txt then open up explorer and navigate to the c:\ root drive and open that new text file with notepad, there you can see all the command line options and explanations a little better. Maybe you should provide us with your exact setup so we can be a little more clear on the command line options to give you. question 1 what directory is mysql installed in?_________________________________________ question 2 what is the old path where all the audio files are?________________________________________ question 3 what is the new path where all audio files have been moved to?_____________________________________ question 4 what is the name of the mysql database sam uses?________________________________________ Answer those questions and we can give you a more definitive answer. p.s. I understand your frustration, been there done that, but yelling and venting your frustration at those who are trying to assist and help you does not really motivate us the help you further. James Henline wrote: > Say that you put your wedding ring in a silver box, inside of a black > box inside of a gray box inside of an orange box. > > So now you know you just have to find the orange box and then inside > will be a gray box, with a black box and a silver box, inside there is > your wedding ring. > > Now, say I come along and and remove the orange box and in its place > put a green box. Now you cannot find your ring cause your looking for > an orange box. > > This is exactly what is happening with SAM. > > You need to calm down, take a breather and read the instructions you > were given, the CD your typing is is a command, it means Change > Directory. You type in: > > cd c:\ (enter) > > And it will change the directory to the C directory. > > When changing your music location it can be easy to solve but it does > take patience. > > > > James Henline. > Help Desk Manager > Development Manager > Spacial Audio Solutions LLC. > 972-739-6420 ext: 110 > www.audiorealm.com > www.spacialnet.com > www.spacialaudio.com > > CONFIDENTIALITY NOTICE: This email, including any attachments, > contains information from SpacialAudio Solutions LLC., which may be > confidential or privileged. The information is intended to be for the > use of the individual or entity named above. If you are not the > intended recipient, be aware that any disclosure, copying, > distribution or use of the contents of this information is prohibited. > If you have received this email in error, please notify the sender > immediately by "reply to sender only" message and destroy all > electronic and hard copies of the communication, including > attachments. > > > > On Sat, Nov 1, 2008 at 11:46 PM, Antifmradio > <[email protected]> wrote: >> youve got to be kidding. >> >> i just tried that process and i got to >> " 1st command " >> cd \ >> >> i typed that in and nothing. i just drops me down to the next line and iwth >> C:> in the begining >> >> i was able however to get a mysqldump HELP list but thats just completely >> insane the amount of information in need to look through >> line by line. >> I just wanted to change a drive location its looking for. >> >> NONE of the php or installation files for SAM are located on this new drive. >> The only thing on the new drive is the audio files that i put in >> None of the audio files that come with SAM are on the new drive. they are on >> the computers hard drive >> and that is NOT changing >> >> >> >> ----- Original Message ----- From: "dstjohn" <[email protected]> >> To: "Antifmradio" <[email protected]> >> Sent: Saturday, November 01, 2008 11:30 PM >> Subject: Re: [General-discussion] How to change DRIVE location in SAM >> >> >>> Use sql maestro for mysql, you can do dumps visualy with there tools. >>> >>> command line go to the bin directory of where ever mysql installed and you >>> will see a commnad line tool >>> in there called mysqldump >>> just start up a command prompt and cd to that directory. >>> example >>> >>> start -> run -> cmd >>> 1st command >>> cd \ >>> 2nd command >>> cd C:\path\to\mysql\bin >>> 3rd command >>> mysqldump --help or mysqldump /? >>> >>> the 3rd command will reveal all options >>> 4th command >>> mysqldump --user=root --password=123456 --opts --databases=SAMDB > >>> C:\SAMDB-bak.sql >>> i could be wrong on the flag --databases, it could be singular --database >>> >>> then to reimport the dumped file thats been changed after you notepad it >>> and change the paths >>> from that same directory with the command line >>> mysql --user=root --password=123456 < C:\SAMDB-bak.sql >>> >>> viola should be all done. >>> >>> >>> Hope that helps. >>> >>> >>> Antifmradio wrote: >>>> ok now heres a good question >>>> how do a MYSQL dump of the SAM DB? >>>> >>>> i was just looking in the MySQL Administtrator and i dont see it there. >>>> While im waiting for the reply,, ill poke around SAM to see >>>> >>>> ----- Original Message ----- From: "dave st john" >>>> <[email protected]> >>>> To: "AntiFMRadio.com" <[email protected]>; >>>> <[email protected]> >>>> Sent: Friday, October 24, 2008 12:55 PM >>>> Subject: Re: [General-discussion] How to change DRIVE location in SAM >>>> >>>> >>>>> Actualy its alot easier then it sounds. >>>>> Do a mysql dump on the sam db, open it notepad. >>>>> >>>>> then just do a simple search and replace >>>>> example >>>>> >>>>> ctrl + H in notepad >>>>> >>>>> Find what: F:\all audio >>>>> Replace with: D:\new audio >>>>> >>>>> the click replace all, save file and reimport. >>>>> >>>>> If the dump makes notepad burp, use wordpad. >>>>> >>>>> If your sam mysql db is on a linux machine to the following. >>>>> >>>>> mysqldump -h localhost -u root -p --opt --databases SAMDB > samdb.sql >>>>> >>>>> then use sed to search and replace >>>>> >>>>> sed 's/D\:\\All Audio/F\:\\New Audio/' /path/to/samdb.sql > >>>>> new.samdb.sql >>>>> >>>>> You may need to work out the escape \ on the : and \ characters in that >>>>> command, as sed is sensative to regexp, thats just an example of how to to >>>>> that on a mass scale. >>>>> >>>>> then you would just reimport with a command like this on linux >>>>> mysql -u root -p < new.samdb.sql >>>>> >>>>> >>>>> >>>>> Hope that helps and gives you some ideas on how to fix that. >>>>> Your initial idea is on the right track, but this procedure takes care >>>>> of it at the core storage area. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> AntiFMRadio.com wrote: >>>>>> Its been said before by doing an SQL command that i can change the >>>>>> Drive location SAM will look for all files. >>>>>> >>>>>> This is related to ONLY my music files so i have a couple questions. >>>>>> >>>>>> Im getting a new external drive and want to dump all my existing music >>>>>> files onto it >>>>>> But i want to make sure SAM will start looking in THAT location instead >>>>>> if me going to EACH file and changing it in SONG INFO. >>>>>> This would otherwise take weeks as there are currently more then 2000 >>>>>> files so >>>>>> >>>>>> 1) What is the command promt steps to change an audio file location in >>>>>> SAM from Drive letter "x" to Drive letter " New X" >>>>>> >>>>>> 2) Would this process work as well?::: >>>>>> a) Goto my MUSIC ALL category in SAM >>>>>> b) Save that listing as a PLAYLIST file ( pls.) >>>>>> c) Open the lps file in a text editor >>>>>> d) Use the FIND & REPLACE function to change all drive locations to the >>>>>> correct one >>>>>> e) Remove the files from my current MUSIC ALL >>>>>> f) Add the pls file to my MUSIC ALL category ( now that it has the new >>>>>> drive location saved in the text of it ) >>>>>> >>>>>> If this a,b,c, steps works, then i can also do this for the other Music >>>>>> Categories i have created. >>>>>> >>>>>> Has anyone tried that? >>>>>> _______________________________________________ >>>>>> 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' >>>> >>> -- >>> This message has been scanned for viruses and >>> dangerous content by MailScanner, and is >>> believed to be clean. >>> >> _______________________________________________ >> 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' -- ^^_ o" )~ '''' David St. John Spacial Audio Network Administrator/Developer Spacial Audio Solutions, LLC 200 E 6th st SUITE 220 Austin, TX 78701 http://www.spacialaudio.com http://www.spacialnet.com http://www.audiorealm.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
