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"" <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> wrote:Alejandro,
----- Original Message -----
From: ""Alejandro D. Burne"" <[EMAIL PROTECTED]>
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
