RE : error 28 from table handler

Thanks Yes the hoster fixed it by cleaning the temp files Jacques Brignon -Message d'origine- De : Sander Smeenk [mailto:[EMAIL PROTECTED] Envoyé : lundi 3 avril 2006 10:32 À : mysql@lists.mysql.com Objet : Re: error 28 from table handler Quoting Jacques Brignon ([EMAIL

Re: error 28 from table handler

Quoting Jacques Brignon ([EMAIL PROTECTED]): 1030 : Got error 28 from table handler % perror 28 OS error code 28: No space left on device Any idea of what might cause that, and what should be done to correct this situation? Aparently the disk that stores your MySQL datadirectory is full

Trans.: Re: error 28 from table handler

Oops forgot to include the list - Message transféré de Jacques Brignon [EMAIL PROTECTED] - Date : Mon, 03 Apr 2006 10:07:58 +0200 De : Jacques Brignon [EMAIL PROTECTED] Adresse de retour :Jacques Brignon [EMAIL PROTECTED] Sujet : Re: error 28 from table handler À : Jos

Re: error 28 from table handler

then the table would have been corrupted - Original Message - From: Jacques Brignon [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 03, 2006 1:58 AM Subject: error 28 from table handler Hi, I am getting the following error when executing a simple SELECT query which used

error 28 from table handler

Hi, I am getting the following error when executing a simple SELECT query which used to work: 1030 : Got error 28 from table handler I did not found that in the manual. When googleing it it seems it may be related to disk space ... The server hosting my application is running MySQL 4.0.23. My

Re: Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

Hi Sebastian, If the new cds_catalog is created with primary key, this should produce a duplicate key error for the second iteration of the second table, as the data selected is from cds_catalog alone, but joining two tables causing cartisian joint to be formed(n*(m- t1.fieldt2.field)), each time

Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

Hi! I have a huge problem with the following insert statement: INSERT INTO cds_catalog SELECT cds_stage.cds_catalog.* FROM cds.cds_catalog, cds_stage.cds_catalog WHERE cds_stage.cds_catalog.prodidcds.cds_catalog.prodid; Whenever I'm running it, it produces the error

Re: Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

Sebastian Geib wrote: Hi! I have a huge problem with the following insert statement: INSERT INTO cds_catalog SELECT cds_stage.cds_catalog.* FROM cds.cds_catalog, cds_stage.cds_catalog WHERE cds_stage.cds_catalog.prodidcds.cds_catalog.prodid; Whenever I'm running it, it

Re: Erro:Got error 28 from table handler!

[EMAIL PROTECTED] wrote: qual o significado da seguinte menssagem de erro do MySQL: Got error 28 from table handler? [EMAIL PROTECTED] egor]$ perror 28 Error code 28: No space left on device -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email

Erro:Got error 28 from table handler!

Olá, qual o significado da seguinte menssagem de erro do MySQL: Got error 28 from table handler? Obrigado, Paulo. --- Inscreva-se na Maratona iBest para concorrer a prêmios! São 2 casas, 11 Ford EcoSport e 60 computadores. Participe já: http://maratona.ibest.com.br -- MySQL General

Re: Erro:Got error 28 from table handler!

Use the command perror Here's yours $ perror 28 Error code 28: No space left on device So get some disk ! Aman Raheja http://www.techquotes.com On Mon, 19 Jul 2004 16:30:05 -0300, [EMAIL PROTECTED] wrote : Olá, qual o significado da seguinte menssagem de erro do MySQL: Got error

MySQL Error 28

Hi List I got an no space left on device error. Is there a way to drop an index without having MySQL create a temporary table? Can I delete the .myi file directly from the operating system? Thanks in advance Oswaldo Castro

myisamchk - error 28

I am using mysql 3.23.54 and am trying to repair the index, using myisamchk -o tablename.MY and am getting the following error: - recovering (with keycache) MyISAM-table 'msg.MYI' Data records: 498802 myisamchk: Error writing file 'msg.TMD' (Errcode: 28) myisamchk: error: 28 when writing

Re: myisamchk - error 28

to repair the index, using myisamchk -o tablename.MY and am getting the following error: - recovering (with keycache) MyISAM-table 'msg.MYI' Data records: 498802 myisamchk: Error writing file 'msg.TMD' (Errcode: 28) myisamchk: error: 28 when writing to datafile MyISAM-table 'msg.MYI' is not fixed

Error 28

DO not know what I have changed, but afte mmonths of using mysql without problems - NOW I get ERROR 28 ( (errno: 28) and cannot create new databases. Does anybody know how to fix this Thanks Robert

Re: Error 28

Perhaps it's this... C:\perror 28 Error code 28: No space left on device David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error 28

On 01-Apr-2003 Hutterer wrote: DO not know what I have changed, but afte mmonths of using mysql without problems - NOW I get ERROR 28 ( (errno: 28) and cannot create new databases. Does anybody know how to fix this Thanks Robert localhost.dread$ perror 28 Error code 28

ERROR 1030: Got error 28 from table handler

Hello, I get the a table handler error (ERROR 1030: Got error 28 from table handler), when using mySQL to evaluate numerious queries in a loop (from Java), after a certain number of successfully evaluated queries. My impression is that it is caused by the appearance of large files in /tmp

Drop Index - Error 28

Hi List I have a table with 90 Millions records and 8 indexes (75GB). I am trying to drop one of them but I get an errorcode 28 (no space left on device). df- v gives me an extra 27% of free space. My questions: Does MySQL use temporary areas to drop indexes and for what ? Is there a way to

Re: Drop Index - Error 28

Yes, it builds a new index file before deleteing the old. Oswaldo Castro wrote: Hi List I have a table with 90 Millions records and 8 indexes (75GB). I am trying to drop one of them but I get an errorcode 28 (no space left on device). df- v gives me an extra 27% of free space. My questions:

database create fails with error 28

shell safe_mysqld --user=mysql shell mysqladmin -u root password 'mypassword' shell mysqladmin -p create SomeDatabase ** failed: errno=28 What the hell is error 28? Where can I find description? mysqlcheck --all-databases # says everything is ok Submitter-Id: submitter ID Originator

Re: database create fails with error 28

What the hell is error 28? Where can I find description? mysqlcheck --all-databases # says everything is ok mysql does come with a little utiltiy, perror, which can be used to translate error numbers into readable messages: $ perror 28 Error code 28: No space left on device Did you check

Error 28

I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm trying to add an auto_increment ID field to 2 tables that already have data in them.. 1 table worked fine, the other table I get Got Error 28 from Table Handler can anyone tell me why I get this? TIA

RE: Error 28

PROTECTED] Subject: Error 28 I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm trying to add an auto_increment ID field to 2 tables that already have data in them.. 1 table worked fine, the other table I get Got Error 28 from Table Handler can anyone tell me why I get

Re: Error 1030: got error 28 from table handler

Hello. shell perror 28 Error code 28: No space left on device in other words: to process the query, MySQL creates a temporary table on disk and you are running out of disk space. You may want to consider to change the location of the directory used for temporary files. Bye,

RE: Error 1030: got error 28 from table handler

On 29-May-01 Griff Hamlin wrote: Hello, snip I have tried the set SQL_BIG_TABLES flag set to 1, but that did not help and now I'm out of ideas. Any suggestions would be appreciated. localhost.dread$ perror 28 Error code 28: No space left on device put --tmpdir on a bigger disc.