Dear list, yesterday I imported some tables from MS Access via ODBC into my brand new MySQL 4.0.4 server. Everything went fine, but the tables did not have a primary key, so I did the following:
mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL PRIMARY KEY; ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to '.\trainee\#sql2-648-2.MYI' (Errcode: 13) As PERROR says, 13 is "permission denied". What's that? I can do the following: mysql> CREATE TABLE auftrag_2 SELECT * FROM auftrag; Now, I can ALTER the auftrag_2 TABLE with no problems at all. Trying a workaround, I switched the default-table-type to innodb. Now, all the Access tables I import become innoDB tables, and I can ALTER TABLE "auftrag" like above without getting error 13. However, innoDB tables have a MyISAM style .frm file. I get a quite similar error when I try the following: mysql> ALTER TABLE auftrag ADD FOREIGN KEY (Auftraggeber) REFERENCES auftraggeber(Schl); ERROR 1005: Can't create '.\trainee\#sql-6fc_2.frm'. (Error: 150) Seems to be an (internal) temporary table problem. Does anyone know what's happening, and how to solve this prob? Thanks alot in advance! Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 --------------------------------------------------------------------- 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
