Hi!
On Aug 21, Nils Valentin wrote:
> Hello MySQL Fans,
>
> This time I am using 4.0.13-max (tar format from www.mysql.com) on
> Redhat 9.
>
> I have an understanding question why would the command SHOW VRAIABLES
> give me once the real output and once the symlink ouput for directory
> names ?
>
> Sample (datadir and basedir) :
>
> mysql> SHOW VARIABLES LIKE '%dir%';
> +----------------------------+--------------------------------------------+
> | Variable_name | Value |
> +----------------------------+--------------------------------------------+
> | basedir | /usr/local/mysql-max-4.0.13-pc-linux-i686/ |
> | datadir | /usr/local/mysql/data/ |
The logic is, that MySQL need to acess files below basedir, as some dirs
(e.g. share/charsets) are defined relative to it. And as basedir can be
a relative symlink, it should be resolved before doing chdir() from
inside MySQL (in fact, symlink resolving was added as a bugfix to get
around relative symlinks).
datadir, instead, is never used explicitly, MySQL only does chdir()
into it on startup, so it does not matter whether it's resolved or not.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
