re: SELECT * INTO OUTFILE results with Errcode 28

2002-09-12 Thread Victoria Reznichenko
Andreas, Thursday, September 12, 2002, 3:56:58 PM, you wrote: AM> After a query AM> SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY AM> ENCLOSED BY '"' FROM testtable AM> the following error occurs: AM> Error writing file

Re: SELECT * INTO OUTFILE results with Errcode 28

2002-09-12 Thread Gerald Clark
perror 28 Error code 28: No space left on device Andreas Metzner wrote: >Hi All, > >After a query >SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY >ENCLOSED BY '"' FROM testtable > >the following error occurs: >

SELECT * INTO OUTFILE results with Errcode 28

2002-09-12 Thread Andreas Metzner
Hi All, After a query SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' FROM testtable the following error occurs: Error writing file 'test.csv' (Errcode: 28) The file was written partially indeed, but not includin

SELECT * INTO OUTFILE results with Errcode 28

2002-09-12 Thread Andreas Metzner
Hi All, After a query SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' FROM testtable the following error occurs: Error writing file 'test.csv' (Errcode: 28) The file was written partially indeed, but not includin

Errcode 28 then 122?

2001-05-04 Thread Mailing
ERROR 3: Error writing file '/tmp/MYRuTInF' (Errcode: 28) Other people with this problem have been told to redirect their TMPDIR to another location. The /tmp is mounted on /: [root@www /]# df -a Filesystem 1k-blocks Used Available Use% Mounted on /dev/hda1

Re: Error writing file './mydb/mytable.frm' (Errcode: 28)

2001-03-15 Thread Gerald L. Clark
Ken Whitmore wrote: > > Somehow, our MySQL server just started giving the error: > Error writing file './mydb/mytable.frm' (Errcode: 28) > whenever I try to create a table using the following: > CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRI

Error writing file './mydb/mytable.frm' (Errcode: 28)

2001-03-15 Thread Ken Whitmore
Somehow, our MySQL server just started giving the error: Error writing file './mydb/mytable.frm' (Errcode: 28) whenever I try to create a table using the following: CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT); Precisely where can

errcode:28

2001-02-08 Thread Webmaster
Hi, I am a begginner in linux and mysql and yesterday after trying to create a table in database test i receive this error: - error writing file ./test/ames.frm (errcode:28). After searching for the cause of this error i think i have discovered it: - my disk partition /dev/hda7 (150MB) in which