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]
