Solved

MySQL Error

Posted on 2004-09-21
6
267 Views
Last Modified: 2012-05-05
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)
0
Comment
Question by:fyness
  • 4
  • 2
6 Comments
 
LVL 26

Accepted Solution

by:
ushastry earned 250 total points
ID: 12112008
Hi,


This means there is No space left on device

You will get a file perror in mysql/bin.. when you run this you will see the cause for this..

$perror 28
Error code  28:  No space left on device

check here

http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
0
 

Author Comment

by:fyness
ID: 12112059
do you know how to fix it?
0
 
LVL 26

Expert Comment

by:ushastry
ID: 12112163
You have to ask your Admin about this one. like he can make free space etc..
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:fyness
ID: 12112199
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??
0
 
LVL 26

Expert Comment

by:ushastry
ID: 12112289
0
 
LVL 26

Expert Comment

by:ushastry
ID: 12149605


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
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Creating and Managing Databases with phpMyAdmin in cPanel.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now