469,106 Members | 2,314 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

SHOW VARIABLES LIKE '%dir%'; (basedir and datadir)

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/ |
| bdb_logdir | |
| bdb_tmpdir | /tmp/ |
| datadir | /usr/local/mysql/data/ |
| innodb_data_home_dir | |
| innodb_log_arch_dir | ./ |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| tmpdir | /tmp/ |
+----------------------------+--------------------------------------------+
9 rows in set (0.04 sec)
Best regards

Nils Valentin

Tokyo/Japan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 2241

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by lkrubner | last post: by
reply views Thread by Nils Valentin | last post: by
1 post views Thread by Guru Prasad | last post: by
1 post views Thread by pontarolo | last post: by
reply views Thread by Gary Herron | last post: by
4 posts views Thread by aldsaldrin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.