I am using 4.0.16 compiled with the following configure command on RedHat Linux 9.0:
> CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql-4.0.16 --enable-assembler --with-mysqld-ldflags=-all-static
I have noticed a few various things in relation to the configure script and the my.cnf/command line variables.
1) If I specify a “--prefix” (for example /usr/local/mysql) and the ./configure script has a “sysconfdir” variable that points to [PREFIX/etc] why does a config file of /usr/local/mysql/etc/my.cnf not get read? Or I guess I should say why doesn’t the /etc/my.cnf location get overridden once I have specified a new location for the “sysconfdir” variable?
2) The ./configure script has two variables “datadir” and “localstatedir” that respectively point to [PREFIX/share] and [PREFIX/var]. From the configure scripts perspective the variable “localstatedir” is the location for a my.cnf file and is the directory where the databases will be stored. While the “datadir” appears to contain locale specific information. The problem I see is that the my.cnf and command line variables also have a “datadir” variable but it is the means of telling mysql where to find the directory that contains the database folder or the “localstatedir” location from the configure script thus the variable names do not match up and it proved to be very confusing. And in the manual section 4.1.2 is says you can locate a my.cnf file in DATADIR/ but it took some time to realize that this is the datadir from the mysqld command line variable not the ./configure script datadir variable.
Thanks in advance for you time.
Bret Jordan [EMAIL PROTECTED]
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Bret Jordan Dean's Office
Computer Administrator College of Engineering
801.585.3765 University of Utah
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
