Solved

MySQL Error

Posted on 2004-09-21
6
268 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Creating and Managing Databases with phpMyAdmin in cPanel.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

896 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

15 Experts available now in Live!

Get 1:1 Help Now