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) 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 ---------------------------------------------------------------- Gloor Informatik Zurlindenstr. 215 a 8003 Zürich Tel: 01 461 24 11 Fax: 01 461 22 39 [EMAIL PROTECTED] --------------------------------------------------------------------- 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