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. >
