Home / server / Questions / 130189
Accepted
Alan Storm
Asked: 2010-04-08 09:07:20 +0800 CST

Determine Configured Location of MySQL's data directory OR all loaded *.cfn Locations

  • 772

I'm not a sys-admin, but sometimes I play one at work.

I've inherited a virtual server that had MySQL installed from source. I'm gathering as much information about the install as I can (original people who installed it are, of course, not a resource).

How can I find

  1. The default/current location of the MySQL binary files (often stored in a directory named data?)

  2. Any default or custom loaded cnf files?

Looking for solutions that are a bit more sophisticated than a find / -iname '*.cnf' :)

linux mysql database

1 Answers

  1. Best Answer

    When compiling from source, /usr/local is the default prefix. Some people like to use the standard system-wide locations, such as /usr, instead even though it could be argued that it breaks the hierarchy standards.

    MySQL's default directory to store all variable files such as configuration and databases is data. The default system-wide configuration file is my.cnf.

    Ultimately, short of searching the filesystem, would be to look at the process list (ps aufx) and see where MySQL is running from, as the parameters MySQL is started with would identify its location.

    • 1