> On Fri, 4 Oct 2002, Stephan Gloor wrote: > > > When trying to create an index on > > > > Table ANSCHLUSS: > > | ID | int(11) | | PRI | NULL | auto_increment | > > | TELEFON | varchar(20) | | MUL | | | > > | REGION | int(11) | | | 0 | | > > | LAND | int(11) | | | 0 | | > > | NETZ | tinyint(4) | | | 0 | | > > | PROTOKOLLTYP | tinyint(4) | | | 0 | | > > | ANZAHLANRUFE | int(11) | | | 0 | | > > | AUSCALLERID | tinyint(4) | | | 0 | | > > > > containing 481484 records, > > > > mysql yields > > > > mysql> CREATE INDEX INDX_ANSCHLUSS ON ANSCHLUSS(TELEFON, REGION, LAND, > > NETZ); > > ERROR 1: Can't create/write to file '/home/data/mysql/tmp/STabnagj' > > (Errcode: 13) > > Stephan, > > tsp@host:~> perror 13 > Error code 13: Permission denied > > It must have to do with permissions; > whats the result of 'ls /home/data/mysql/tmp/' ? > > Thomas >
The mysql is running from the root user the rights for the temp directory are: drwxr-xr-x 2 root root 35 Oct 4 08:08 tmp/ > > > Only 18% of the disk are in use, df shows that there are 28'103'092 KB > > available. root, the owner has rights enough, mysql is started from the root > > user. > > (drwxr-xr-x 2 root root 35 Oct 4 08:08 tmp/) > > > > OS: Linux > > > > Thanks and regards for any comment. > > > > Stephan Gloor > filter: sql, query > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
