Hi, i can't set the tmpdir Variable on the mysql-server-5.0.22 in the config file. However, setting it in the start command works.
mysql> show variables like "version";
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| version | 5.0.22 |
+---------------+--------+
1 row in set (0.00 sec)
mysql> set tmpdir="/var/tmp";
ERROR 1193 (HY000): Unknown system variable 'tmpdir'
mysql> show variables like "tmpdir";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| tmpdir | |
+---------------+-------+
1 row in set (0.00 sec)
Changing the starting command in mysqld start script:
/usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file="$mypidfile" --log-error="$errlogfile" >/dev/null 2>&1 &
to:
/usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file="$mypidfile" --log-error="$errlogfile" --tmpdir=/var/tmp >/dev/null 2>&1 &
works.
Interactive mysql shows:
mysql> show variables like "version";
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| version | 5.0.22 |
+---------------+--------+
1 row in set (0.00 sec)
mysql> show variables like "tmpdir";
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| tmpdir | /var/tmp |
+---------------+----------+
1 row in set (0.00 sec)
Setting the tmpdir Variable in the my.cnf file also does not work.
my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
set-variable = tmpdir=/var/tmp
Please, can someone confirm this? How can this be solved? Thanks.