asked on

MySQL Error

Hi,

Does anyone know what this error means (I'm trying to create the table Transfers, Ciaran is the name of the database)

Thanks
Suzy

ERROR 3: Error writing file './ciaran/Transfers.frm' (Errcode: 28)

ASKER CERTIFIED SOLUTION

Umesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

fyness

ASKER

do you know how to fix it?

Umesh

You have to ask your Admin about this one. like he can make free space etc..

fyness

ASKER

will i am admin (more or less) its off a local server so we have access to the whole server

Do you know what causes it to fill up? I did a delete of over 30000 enteries today alone, don't see why we would run out of disk space??

Umesh

Take a look at here..

http://dev.mysql.com/doc/mysql/en/Cannot_create.html

Umesh

Can't create/write to file './ciaran/Transfers.frm'.
this means that MySQL can't create a temporary file for the result set in the given temporary directory. (The above error is a typical error message on Windows, and the Unix error message is similar.) The fix is to start mysqld with --tmpdir=path or to add to your option file: (on windows this would be my.ini under winnt/windows) in your case my.cnf might be located in /etc/my.cnf

[mysqld]
tmpdir=/tmp

assuming that the `/tmp' directory exists.
Check also the error code that you get with perror. One reason may also be a disk full error;

shell> perror 28
Error code 28: No space left on device