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]
