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 > 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