SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast Sebioni's Avatar
    Join Date
    Jun 2001
    Location
    France
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL automatic Start up

    Hi everyone,

    I am creating a small intranet database for a client. I have installed MySql and Apache on their machine but I don't want them to have to manually start the MySQL engine every morning using the MS-dos window.

    Does anyone know how I could start the MySQL engine when the computer boots? They are using Windows as their OS.

    Any help would be greatly appreciated.

    Cheers!
    Seb

  2. #2
    SitePoint Enthusiast Sebioni's Avatar
    Join Date
    Jun 2001
    Location
    France
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Come on,

    One of you guys must know this. I can feel it....
    Seb

  3. #3
    SitePoint Wizard
    Join Date
    Jul 2001
    Location
    The Netherlands
    Posts
    2,617
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you are using this on an NT-box, which means Windows 2000 and Windows XP as well, you can use the following code:

    Code:
    C:\MySQL\bin\mysqld-nt --install
    Run this code by clicking Start > Run and MySQL will be installed as a system service, and therefore start every time the pc boots.
    You might need to change the path to MySQL accordingly, or even add a space between mysqld and -nt (for some reason I have to on my pc, still haven't figured out why ).

    I hope that helps.

  4. #4
    SitePoint Enthusiast Sebioni's Avatar
    Join Date
    Jun 2001
    Location
    France
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for that, Mark. However, they use Windows 98 and I am sure the command will be different.

    Also, how do I stop this option once I have managed to start it when the computer boots? In other words, what is the command to stop MySQL start at start up?

    Cheers
    Seb

  5. #5
    SitePoint Zealot
    Join Date
    Feb 2002
    Location
    UK
    Posts
    146
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    one way is:

    create a shortcut to your mysql program.

    copy shortcut to 'C:\Windows\Start Menu\Programs\StartUp' folder. (assuming you installed windows in C:\Windows)

    if you want to stop the program loading at startup, delete the shortcut.

    hope this helps

  6. #6
    SitePoint Enthusiast Sebioni's Avatar
    Join Date
    Jun 2001
    Location
    France
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    For some reason, I was looking for a much more complicated solution. I was even messing up with the autoexec.bat file.

    Thanks for pointing out a straight forward/easy solution.

    Cheers
    Seb

  7. #7
    SitePoint Enthusiast
    Join Date
    Feb 2002
    Location
    Brampton, Ontario
    Posts
    88
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Mark T.
    If you are using this on an NT-box, which means Windows 2000 and Windows XP as well, you can use the following code:

    Code:
    C:\MySQL\bin\mysqld-nt --install
    Run this code by clicking Start > Run and MySQL will be installed as a system service, and therefore start every time the pc boots.
    You might need to change the path to MySQL accordingly, or even add a space between mysqld and -nt (for some reason I have to on my pc, still haven't figured out why ).

    I hope that helps.
    I am trying to run it on an NT 4 OS, and for some reason, it gives me an error stating that "could not start MySql service... then says Error 1067: the process terminated unexpectedly...

    I'll try putting a space between the mysql and the -nt... and see if that works....

    also, when i installed it on win 2k pro... i used
    Code:
    C:\MySQL\bin\mysqld-nt -install
    does it make a difference if i used one dash "-" or two "--" ??


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
  •