changing directories in DOS

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Im trying to teach myself MySQL from the "teach yourself" book but cannot change into the MySQL\bin directory in dos. The path should be C:\Program Files\MySQL\MySQL Server 5.0\bin, and so im using the command cd C:\Program Files\MySQL\MySQL Server 5.0\bin, but I keep getting an error saying "to many parameters". Ive tries typing the word "Program_Files" to remove any spaces but no joy.

Is there anyone here that remembers MSDOS???

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Stu,

I would suggest trying each folder one at a time as a dos command. so type cd c:\program files, followed by cd \mysql followed by cd \mysql server 5.0 etc to see where it stops at. I have a feelingi t may be the 5.0 is confusing the dos. Dos used to recoginsed the . as a seperator for filenames hence why there was a 8.3 or 12.3 filename format. The . is followed by and extension such as exe etc so it might be that the Dos command thinks Mysql server 5.0 is a file that it needs to load or run?

If not then i have no idea. Are you actually using DOS (6.2 5.1 etc) or are you doing this from the XP CMD prompt? I never consider this "Proper dos" so the above probably dosent count.

 

try entering the filepath in quotes. Spaces in a command line indicate additional arguments. you need to let it know that it should treat it all as a single argument.

 

hello Stu, I had a similar problem when installing j2E JDK 5.0 from the sams teach yourself book. Has the book got a website for info about installing SQL? having to install a source from the Command line is messy isnt it? I had a nightmare getting mine sorted. I assume you problem is similar. Have you tried editing the PATH variable in the system properties that may direct you back to your SQL directory. Justa thought mate but I am ot great on DOS.

C

 

Cheers Twizz. I've tried that already. I cant get past cd c:\program files. I get an error "to many parameters - files".

Im not sure you can use spaces but I dont know what you have to replace them with.

 

Stu,

I have tried that here and it works. I goto the cmd prompt in XP, type cd c:\program files and it goes to the correct folder. You could try the ~ between program and files so it reads cd c:\program~files but i always thought it was underscore (_) that was used when names were too long in DOS.

 

stuPeas,

Try...

C:\PROGRAM~1\MYSQL\MYSQL_S~1\BIN

 

ding ding ding! We have a winner!!!

 

I actually posted a thanx response ages ago but something must have gone wrong.

YES mike is correct: using quotes solved the problem.

Thanx to all who responded biggrin

 

Is this the command prompt in windows 2000 or better, then it would be "c:\program files\mysql\my sql ser..." (so just put quotation mark around it)
If it is 'proper' dos, it would be c:\progra~1\mysql\mysqls~1\bin.

 

Why don't I read the thread first before answering

 

We all do it sometimes mate.
Anyway, it was Windoze 98.

 

And it is dangerous to assume the short filename equivalents like whatever~1. The number is assigned sequentialy, so if there was something else with the same start string it would be whatever~2.

(And, yes, I know that the prefix whatever is too long to actualy happen!)

Harry.

 

hey Harry, want to talk about WAP technology?

 

Alternatively, just hack your registry to add a 'Command Prompt Here' entry on all your directories.

In fact, you don't have to edit the registry (in case you're allergic or something). Try the following:

Open up Explorer and go to 'Tools' - 'Folder Options' - 'File Types'.

Go to the 'NONE - Folder' entry, highlight it and click the 'Advanced' button.

Click the 'New' button and in the prompt type "Command Prompt" minus the quotes.

In the App Block section type "cmd.exe" - again minus quotes.

Save out of everything.

Now open up explorer again - you should have a 'Command Prompt' option on the context menu of your folders.

 

Er - why would I want to do that?

And which meaning of WAP were you refering to?

Harry.

 

That looks like a pretty cool hack (if it works). Anyway ive given up trying to get MySQL working with 98. I cant even figure out what question I should ask to try to get it going!!

 

I see you've not been following the posts of one of our new members (god), otherwise you would know.
Never mind mate

 

No probs. I'm in catchup mode as I've been away in a meeting all day, and I have been skipping those threads as I can't work out what he is trying to say!

Harry.

 

I dont care anymore. Im just having some fun with him, following him around, making as much sense as him. we will see who cracks first.