newbie: check if mysql server is running

Thread view:

Johan - 03 Oct 2003 19:37 GMT

Hi,

I'm trying to figure out how to check wether or not the mysql server is
up and running with my java program, and if not start the mysql server.
I've succeeded in connecting to the server, so thats not the problem.
I've looked at various tutorials and information about mysql and JDBC,
but I didn't find the answer. Maybe one of You can help.

thanks in advance, Johan

Reply to this Message

Lothar Kimmeringer - 03 Oct 2003 20:04 GMT

> I'm trying to figure out how to check wether or not the mysql server is
> up and running with my java program, and if not start the mysql server.

Open the socket to the remote-port of MySQL. If it's not throwing
an exception, it's up.

Regards, Lothar

Signature

Lothar Kimmeringer E-Mail: spamfang@kimmeringer.de
PGP-encrypted mails preferred (Key-ID: 0x8BC3CD81)

Always remember: The answer is forty-two, there can only be wrong
questions!

Reply to this Message

Johan - 03 Oct 2003 20:13 GMT

>>I'm trying to figure out how to check wether or not the mysql server is
>>up and running with my java program, and if not start the mysql server.
>
> Open the socket to the remote-port of MySQL. If it's not throwing
> an exception, it's up.

Thanks for Your reply, but sorry this is maybe simple stuff,
unfortunately not for me :-(
How can I do this (or where can I find information about this subject?)
When there is an exception how do I start the server with my program
(e.g. not with the console or mysqladmin)
Thanks Johan

> Regards, Lothar

Reply to this Message

Lothar Kimmeringer - 03 Oct 2003 21:09 GMT

>>>I'm trying to figure out how to check wether or not the mysql server is
>>>up and running with my java program, and if not start the mysql server.
[quoted text clipped - 5 lines]
> unfortunately not for me :-(
> How can I do this (or where can I find information about this subject?)

What subject in detail? Opening sockets?
http://java.sun.com/j2se/1.4.2/docs/api/java/net/Socket.html
Starting a process from Java?
http://java.sun.com/j2se/1.4.2/docs/api/java/lang/Runtime.html#exec(java.lang.String)
or others dependent on the environment-variables that might
be necessary to be set.

> When there is an exception how do I start the server with my program
> (e.g. not with the console or mysqladmin)

In the bin-directory there should be something like mysqld.
Dependent on the operating-system you're running on a
/etc/rc.d/mysql start
does everything for you.

Maybe another database fits better for your needs. Without knowing
more (my crystal-ball is quite inaccurate these days due to
the little distance of mars to earth) maybe

http://mckoi.com/database/

is something for you.

Regards, Lothar

Signature

Lothar Kimmeringer E-Mail: spamfang@kimmeringer.de
PGP-encrypted mails preferred (Key-ID: 0x8BC3CD81)

Always remember: The answer is forty-two, there can only be wrong
questions!

Reply to this Message

newbie: check if mysql server is running

Free Magazines