MySQL Forums
Forum List  »  MySQL Administrator

mysql-5.0.22 - setting tmpdir variable (enable InnoDB)
Posted by: Thomas Kettenbach
Date: September 20, 2007 10:07AM

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.

Options: ReplyQuote


Subject
Written By
Posted
mysql-5.0.22 - setting tmpdir variable (enable InnoDB)
September 20, 2007 10:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.