Alejandro,
please search the bugs.mysql.com database about known --tmpdir bugs.
If TMPDIR works, it is a fine workaround.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
----- Original Message -----
From: ""Alejandro D. Burne"" <alejandro.dburne@stripped>
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 2:40 PM
Subject: Re: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode:
13)
> Heikki I do it, in my.cnf on [mysqld] section I add:
> tmpdir=/tmp
>
> then I try:
> /usr/bin/mysqld_safe --tmpdir=/tmp --datadir=/var/lib/mysql --user=mysql
>
> with the same result
>
> If I change TMPDIR enviroment variable to /tmp works fine.
>
> I forgot to say I install mysql from rpm.
>
> Alejandro
>
> On Fri, 3 Dec 2004 22:01:37 +0200, Heikki Tuuri <heikki.tuuri@stripped>
> wrote:
>> Alejandro,
>>
>> ----- Original Message -----
>> From: ""Alejandro D. Burne"" <alejandro.dburne@stripped>
>> Newsgroups: mailing.database.myodbc
>> Sent: Friday, December 03, 2004 7:20 PM
>> Subject: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode:
>> 13)
>>
>> > After installing MySQL 5.0.2 on MDK10.0 mysqld doesn't start with
>> > error:
>> >
>> > "Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)"
>>
>> InnoDB, and mysqld in general, must be able to create temporary files.
>>
>> http://dev.mysql.com/doc/mysql/en/Temporary_files.html
>> "
>> MySQL uses the value of the TMPDIR environment variable as the pathname
>> of
>> the directory in which to store temporary files. If you don't have TMPDIR
>> set, MySQL uses the system default, which is normally `/tmp', `/var/tmp',
>> or
>> `/usr/tmp'. If the filesystem containing your temporary file directory is
>> too small, you can use the --tmpdir option to mysqld to specify a
>> directory
>> in a filesystem where you have enough space.
>> "
>>
>>
>>
>> > I think it's a problem with innodb, if I add skip-innodb on my.cnf
>> > mysqld starts up:
>> >
>> > 041203 14:04:01 mysqld started
>> > 041203 14:04:01 [Warning] Asked for 196608 thread stack, but got 126976
>> > /usr/sbin/mysqld: ready for connections.
>> > Version: '5.0.2-alpha-standard-log' socket:
>> > '/var/lib/mysql/mysql.sock'
>> > port:
>> >
>> > But when I enable innodb (#skip-innodb on my.cnf);
>> > 041203 14:04:56 mysqld started
>> > 041203 14:04:56 [Warning] Asked for 196608 thread stack, but got 126976
>> > ./usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibu6vdue'
>> > (Errcode: 13)
>> > 041203 14:04:56 InnoDB: Error: unable to create temporary file; errno:
>> > 13
>> > 041203 14:04:56 [ERROR] Can't init databases
>> > 041203 14:04:56 [ERROR] Aborting
>> >
>> > 041203 14:04:56 [Note] /usr/sbin/mysqld: Shutdown complete
>> >
>> > 041203 14:04:56 mysqld ended
>> >
>> > The only way to do work innodb is chmod 777 /root and /root/tmp, =(
>> >
>> > Alejandro
>>
>> Best regards,
>>
>> Heikki Tuuri
>> Innobase Oy
>> Foreign keys, transactions, and row level locking for MySQL
>> InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
>> MyISAM
>> tables
>> http://www.innodb.com/order.php
>>
>> Order MySQL technical support from https://order.mysql.com/
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
