----- Original Message -----
From: ""Alejandro D. Burne"" <alejandro.dburne@stripped>
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.
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'
> 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, =(
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
Order MySQL technical support from https://order.mysql.com/