SitePoint Sponsor

User Tag List

Results 1 to 12 of 12
  1. #1
    SitePoint Member
    Join Date
    Oct 2002
    Location
    Suffolk, UK
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL - installing on F:\ Drive

    Hi,
    Can someone help me out with a problem I have trying to start my server via command prompt on WinXP Pro?
    My hard drive is F:\ and I think this might be the reason...
    When I type:
    F:\> net start mysql
    I get the following:
    A system error has occured.
    System error 1067 has occured.
    The process is terminated unexpectedly.
    I also get a dialog saying:
    "There is no disk in the drive. Please insert a disk into drive \Device\Harddisk\DR1". I can click Continue, Cancel or Try Again.
    Any ideas on how I can configure MySql to install on drive F:\ automatically? I think it may be a setting in it.
    By the way, C:\ on my system is my Zip drive!

    Thanks in advance,
    Stephanie.

  2. #2
    We like music. weirdbeardmt's Avatar
    Join Date
    May 2001
    Location
    Channel Islands Girth: Footlong
    Posts
    5,882
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There should be a file called my.cnf -- which is basically the config settings. IN there you should be able to set the basedir/install paths etc... I think by default it uses C: whereas you'll need to change it to F: ...
    I swear to drunk I'm not God.
    » Matt's debating is not a crime «
    Hint: Don't buy a stupid dwarf ö Clicky

  3. #3
    SitePoint Member
    Join Date
    Oct 2002
    Location
    Suffolk, UK
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing MySQL on F:\ drive

    Hi,
    Thanks for your reply.
    I have tried changing all the occurences of C:\ in that file to F:\ but it still doesn't work.
    Do I need to do that then reinstall MySQL?
    If I reinstall MySQL do I need to uninstall it first?
    How would I uninstall it? When I go to Add/Remove programs it can't locate the file: C:\mysql\uninst.isu.
    That's because its at F:\mysql\!
    I have tried running the file from there but it won't do anything.

    Thanks,
    Stephanie.

  4. #4
    SitePoint Member
    Join Date
    Oct 2002
    Location
    Suffolk, UK
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well..
    I got over the uninstallation problem because my C:\ drive is my Zip drive so I just made a mysql folder on a zip disc and then copied the uninst file there.
    I tried just installing mysql again before uninstalling and the setup.exe file wouldn't run (it wouldn't do anything when i double-clicked it).
    Now I've uninstalled mysql it STILL won't reinstall.
    I have tried unzipping the downloaded zip files again (to a different folder) and the setup.exe file still doesn't work. (
    Any ideas??
    Thanks,
    Steph.

  5. #5
    We like music. weirdbeardmt's Avatar
    Join Date
    May 2001
    Location
    Channel Islands Girth: Footlong
    Posts
    5,882
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Format and reinstall Windows...no wait, I didn't say that.

    When you say the setup file won't run, what do you mean? That could be stuffed. Might be worth downloading it again.

    I would also consider unplugging your ZIP drive so that C: doesn't exist when the installer wants to go.

    You should probably also read this (in case you haven't) http://www.mysql.com/doc/en/Windows_...vironment.html -- it talks about what to do if the install dir is different to the defaults.
    I swear to drunk I'm not God.
    » Matt's debating is not a crime «
    Hint: Don't buy a stupid dwarf ö Clicky

  6. #6
    SitePoint Member
    Join Date
    Oct 2002
    Location
    Suffolk, UK
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Good news..
    I have got MySQL up and running.
    I made my own my.ini file and put it in the F:\Windows folder.
    It now all works.
    Bad news..
    I can't get IIS to work now!
    Before, I got the today.php file to work and the date displayed fine in I.E.
    Now it can't find the file via localhost.
    When I try to open Internet Information Services via Administration Tools,
    it won't open!
    I have tried to reinstall IIS via Add/Remove Windows Components but it gets
    to the bit where it displays a dialog: Windows XP Setup (which says 'Please
    Wait..') and it just hangs. Nothing happens.
    Please don't tell me I need to reinstall Windows.
    I will have a very large tantrum if I have to do that )!
    Is there another way to remove IIS from my system and then add it back?
    Thanks,
    Steph.

  7. #7
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Steph,

    On occasion, IIS gets "stuck" as you describe and you simply need to reboot for it to start working again.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  8. #8
    SitePoint Member
    Join Date
    Oct 2002
    Location
    Suffolk, UK
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi KYank,
    Thanks for the tip.
    I have tried rebooting but everytime I do now I get a SaveAs dialog box which shows the Administration Tools folder and is asking me to save some sort of .mcs file. In the filname it shows *.mcs (I think it's mcs - it's to do with the management console anyway!).
    It's a bit worrying really.
    If I click Cancel I get an error about Microsoft Management Console. Maybe I should type something in there and save it to see what happens!
    Steph.

  9. #9
    We like music. weirdbeardmt's Avatar
    Join Date
    May 2001
    Location
    Channel Islands Girth: Footlong
    Posts
    5,882
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    From my limited experience I would recommend using Apache, unless there is a really good reason why you want to use IIS.
    I swear to drunk I'm not God.
    » Matt's debating is not a crime «
    Hint: Don't buy a stupid dwarf ö Clicky

  10. #10
    SitePoint Member
    Join Date
    Oct 2002
    Location
    Suffolk, UK
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have tried going down the Apache root only to find I need service pack 1 for Win XP in order to have Apache.
    I can't get SP1 to work! But that's another story )

  11. #11
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    When do you get the dialog box? During shutdown? During startup? At some other time?

    The box seems to be prompting you to save a Microsoft Console configuration... but I don't know why this would be happening at every reboot.

    -Kev.

    Originally posted by stephtaryn
    Hi KYank,
    Thanks for the tip.
    I have tried rebooting but everytime I do now I get a SaveAs dialog box which shows the Administration Tools folder and is asking me to save some sort of .mcs file. In the filname it shows *.mcs (I think it's mcs - it's to do with the management console anyway!).
    It's a bit worrying really.
    If I click Cancel I get an error about Microsoft Management Console. Maybe I should type something in there and save it to see what happens!
    Steph.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  12. #12
    SitePoint Member
    Join Date
    Oct 2002
    Location
    Suffolk, UK
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry I took so long to reply.. I've been away on holiday!
    Where was I? Oh yeah...
    Rebooting.
    Before it reboots I get the SaveAs dialogue box.
    I have now managed to install SP1 for Win XP and I think I'll try the latest version of Apache now which may work better!
    Thanks for your help Kevin.
    PS: Excellent PHP book! I came back from hols to find it with my neighbour! Nice surprise and a good excuse to get out of working LOL!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •