Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MySQL Error

Posted on 2004-09-21
6
Medium Priority
?
280 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:
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
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
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…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month10 days, 23 hours left to enroll

886 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