Hello.
shell> perror 28
Error code 28: No space left on device
in other words: to process the query, MySQL creates a temporary table
on disk and you are running out of disk space.
You may want to consider to change the location of the directory used
for temporary files.
Bye,
Benjami
On 29-May-01 Griff Hamlin wrote:
> Hello,
>
>
> I have tried the set SQL_BIG_TABLES flag set to 1, but that did not help
> and now I'm out of ideas. Any suggestions would be appreciated.
>
localhost.dread$ perror 28
Error code 28: No space left on device
put --tmpdir on a bigger disc.