Page 1 of 1

How to run Apache/MySql from command prompt

PostPosted: 22. March 2010 20:47
by JustMe
Hi all,

Where do I find docs on running Apache and MySQL from the command prompt (vs. setting it to run as a service or using the XAMPP control panel)?

I have login scripts that check my location and domain and then run the software that is appropriate (IIS, Apache, Glassfish, MySql, MS SQL, Postgres, Eclipes, Netbeans, etc.) for the site where I am currently located. I hate having to start these from the XAMPP control panel, but don't want them running as a service.

Any idea?

Thanks,

JustMe

Re: How to run Apache/MySql from command prompt

PostPosted: 22. March 2010 21:08
by Nobbie
You dont need docs about starting Apache or MySQL.

Simply start httpd.exe (Apache) or mysqld.exe (MySQL) from commandline or from explorer (double click). Thats all. You will find the executables in the appropriate bin-folders.

Re: How to run Apache/MySql from command prompt

PostPosted: 22. March 2010 22:02
by JustMe
Nobbie,

Thanks for your response.

2 things.

1) I am still trying to find out where I can get docs on the command line arguments for the executables in the bin folder.
2) With you help, I can now get Apache running. But MySQL still does not. When I call MySQLd.exe, I get the following errors:

100322 13:52:27 [Warning] Can't create test file \usr\local\mysql\data\Protege.lower-test
100322 13:52:27 [Warning] Can't create test file \usr\local\mysql\data\Protege.lower-test
mysqld: Can't change dir to '\usr\local\\mysql\data\' (Errcode: 2)
100322 13:52:27 [ERROR] Aborting

100322 13:52:27 [Note] mysqld: Shutdown complete

Given that I am running windows, shouldn't it at least show me the paths that exist on my machine?

When I try to run either MySql.exe or MySqlD.exe with flags like ?, /?, /help, etc. I just get errors.

Any more ideas?

Thanks,

JustMe

Re: How to run Apache/MySql from command prompt

PostPosted: 24. March 2010 17:22
by JustMe
Hi all,

Well I didn't think what I wanted was that hard and it might have been nice if someone had pointed me in the right direction. Anyway, should anyone search for this (I did first) and not find what they wanted (I didn't), here are the answers.

Don't go to the Apache.org site because they tell you how to do it with a standard install, which XAMPP doesn't do (this is not bad, just FYI)

Here is the code for a batch file that will
1) Start Apache and MySql
2) Load the control pannel
3) Run Netbeans (or change it to your editor of choice)
4) Not wait for you to exit any of those before it will exit (say for an autoexec script)
5) Note that the last use of start uses a path directive as well as the shortcut (.lnk) instead of calling the .exe directly. This approach allows you to configure the shortcut to run the way you want using the shortcut (vs. command line args).

REM Start Apache with no new window
call C:\xampp\apache_start.bat < crlf.txt
REM Start MySQL
call C:\xampp\mysql_start.bat < crlf.txt
REM start the control panel minimized
start "Startup Title" /MIN "c:\xampp\XAMPP-Control.exe"
start "Startup Title" "c:\Program Files\Mozilla Firefox\firefox.exe"
start "Startup Title" /D "C:\Users\developerAcct\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\netbeans\" "NETBEANS.LNK"

A couple of things. The crlf.txt file simply gets around the PAUSE in the XAMPP batch files. I could have edited those, but this way, I can reinstall and not have to remember to edit them again.

You can get info on START by just entering Start /? at a command prompt.

In my case, when my computer starts, it checks the domain. If I am at a clients where we use LAMP, then this script runs. Otherwise, whatever sript that is appropriate will run. I also use SET directives instead of actual paths so that those to can be configured by the environment.

ANyway, feel free to contact me if you want more details.

JustMe