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
Solved

MySQL Error

Posted on 2004-09-21
6
272 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
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.

 

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
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 …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

838 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