1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

changing directories in DOS

Discussion in 'Software' started by stuPeas, Sep 26, 2007.

  1. stuPeas

    stuPeas Megabyte Poster

    774
    12
    76
    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??? :oops:
     
    Certifications: C&G Electronic, CIW Associate (v5).
    WIP: CIW (Website Design Manager)
  2. twizzle

    twizzle Gigabyte Poster

    1,838
    33
    104
    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.
     
    Certifications: Comptia A+, N+, MS 70-271, 70-272
    WIP: Being a BILB,
  3. Fergal1982

    Fergal1982 Petabyte Poster

    4,196
    171
    211
    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.
     
    Certifications: ITIL Foundation; MCTS: Visual Studio Team Foundation Server 2010, Administration
    WIP: None at present
  4. Colin1

    Colin1 Byte Poster

    143
    0
    38
    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 :biggrin
     
    Certifications: Cisco IT Essentials,
    WIP: IT degree, CIW (Web), A+, N+
  5. stuPeas

    stuPeas Megabyte Poster

    774
    12
    76
    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.
     
    Certifications: C&G Electronic, CIW Associate (v5).
    WIP: CIW (Website Design Manager)
  6. twizzle

    twizzle Gigabyte Poster

    1,838
    33
    104
    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.
     
    Certifications: Comptia A+, N+, MS 70-271, 70-272
    WIP: Being a BILB,
  7. r.h.lee

    r.h.lee Gigabyte Poster

    1,011
    52
    105
    stuPeas,

    Try...

    C:\PROGRAM~1\MYSQL\MYSQL_S~1\BIN
     
    Certifications: MCSE, MCP+I, MCP, CCNA, A+
    WIP: CCDA
  8. BosonMichael
    Highly Decorated Member Award

    BosonMichael Yottabyte Poster

    19,136
    462
    374
    ding ding ding! We have a winner!!!
     
    Certifications: CISSP, MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CCNA Security, CCNA Voice, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
    WIP: Just about everything!
  9. stuPeas

    stuPeas Megabyte Poster

    774
    12
    76

    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 :D:biggrin
     
    Certifications: C&G Electronic, CIW Associate (v5).
    WIP: CIW (Website Design Manager)
  10. Tinus1959

    Tinus1959 Gigabyte Poster

    1,539
    42
    106
    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.
     
    Certifications: See my signature
    WIP: MCSD, MCAD, CCNA, CCNP
  11. Tinus1959

    Tinus1959 Gigabyte Poster

    1,539
    42
    106
    Why don't I read the thread first before answering:oops:
     
    Certifications: See my signature
    WIP: MCSD, MCAD, CCNA, CCNP
  12. stuPeas

    stuPeas Megabyte Poster

    774
    12
    76
    We all do it sometimes mate. :D
    Anyway, it was Windoze 98.
     
    Certifications: C&G Electronic, CIW Associate (v5).
    WIP: CIW (Website Design Manager)
  13. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224
    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.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  14. stuPeas

    stuPeas Megabyte Poster

    774
    12
    76
    hey Harry, want to talk about WAP technology?
     
    Certifications: C&G Electronic, CIW Associate (v5).
    WIP: CIW (Website Design Manager)
  15. zebulebu

    zebulebu Terabyte Poster

    3,748
    330
    187
    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.
     
    Certifications: A few
    WIP: None - f*** 'em
  16. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224
    Er - why would I want to do that? :biggrin

    And which meaning of WAP were you refering to?

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  17. stuPeas

    stuPeas Megabyte Poster

    774
    12
    76
    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!!
     
    Certifications: C&G Electronic, CIW Associate (v5).
    WIP: CIW (Website Design Manager)
  18. stuPeas

    stuPeas Megabyte Poster

    774
    12
    76
    I see you've not been following the posts of one of our new members (god), otherwise you would know.
    Never mind mate :oops:
     
    Certifications: C&G Electronic, CIW Associate (v5).
    WIP: CIW (Website Design Manager)
  19. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224
    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! :p

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  20. stuPeas

    stuPeas Megabyte Poster

    774
    12
    76

    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. :D
     
    Certifications: C&G Electronic, CIW Associate (v5).
    WIP: CIW (Website Design Manager)

Share This Page

Loading...