Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MySQL Error

Posted on 2004-09-21
6
Medium Priority
?
279 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 26

Accepted Solution

by:
Umesh earned 750 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:Umesh
ID: 12112163
You have to ask your Admin about this one. like he can make free space etc..
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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:Umesh
ID: 12112289
0
 
LVL 26

Expert Comment

by:Umesh
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

722 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