Finding and printing mysql pid

Question

0.00/5 (No votes)

See more:

C++

MySQL

How can I find and print a mysql pid file using C++ code?

Posted 30-Apr-11 21:18pm

soumava chakraborty

Updated 3-May-11 1:28am

markkuk

v3

Add a Solution

Comments

Sandeep Mewara 1-May-11 4:07am

Any effort?

soumava chakraborty 1-May-11 4:14am

yes sir,,I am giving my best to do this.I have got the success to connect mysql database through a c program.can you help me in this case??thanks for your concern..

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

markkuk · Answer 1 · 2011-05-01T01:13:00

Solution 2

The name of the PID file is stored in the MySQL global system variable pid_file. Use one of the available database APIs to query the variable value, then use the normal C++ file classes to open and read the file.

Posted 1-May-11 1:13am

markkuk

Richard MacCutchan · Answer 2 · 2011-04-30T21:50:00

Solution 1

1. Find out where the file is stored.
2. Decode the contents of the file.
3. Print the results.

Posted 30-Apr-11 21:50pm

Richard MacCutchan

Sergey Chepurin · Answer 3 · 2011-05-01T05:34:00

Solution 3

How about that: If the name of the environment variable is pid_file use GetEnvironmentVariable() function to acquire the corresponding value where suppose to be path to the file, and then print it out.
Here is the reference GetEnvironmentVariable() and there are samples to use Changing Environment Variables.
Sergey Chepurin.

Posted 1-May-11 5:34am

Sergey Chepurin

Updated 1-May-11 7:22am

v4

Comments

markkuk 1-May-11 14:04pm

It's not an environment variable, it's a MySQL internal system variable.

Sergey Chepurin 2-May-11 2:04am

Then, if you manage to find config (option) file such as my.cnf or mysql.server file you can try to parse it looking for pid_file lines. At least that is what other people do sometimes. Take a look on that code and corresponding files.
Sergey Chepurin.

Kim Togo · Answer 4 · 2011-05-03T01:15:00

Under Windows, the PID file for MySQL is located the same place where database root folder is.

In My.ini file:

MSIL

#Path to the database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"

Under this path, there is a .PID file, that holds the current process id. The filename is the name of the computer.
But if you what to control is MySQL is running or not. Then use the "SC" command tool under Windows.