Hi I'm new with mysql, and I have a problem in a dabase, the file sysmte got full and one table is corrupt, the messages are:
mysql> desc medicionproc; ERROR 1016: Can't open file: 'medicionproc.MYD'. (errno: 144) I tryed to repair it mysql> repair table medicionproc; +-----------------------+--------+----------+-----------------------------+ | Table | Op | Msg_type | Msg_text | +-----------------------+--------+----------+-----------------------------+ | medicion.medicionproc | repair | error | 28 when fixing table | | medicion.medicionproc | repair | error | 28 when writing to datafile | | medicion.medicionproc | repair | status | Operation failed | +-----------------------+--------+----------+-----------------------------+ 3 rows in set (4 hours 57 min 23.95 sec) the directory is: # ls -l total 235234896 -rw-rw---- 1 mysql mysql 8730 May 15 2002 #sql-bc_3de3e.frm -rw-rw---- 1 mysql mysql 17785215724 May 16 2002 #sql-bc_3de3e.MYD -rw-rw---- 1 mysql mysql 3121859584 May 16 2002 #sql-bc_3de3e.MYI -rw-rw---- 1 mysql mysql 8788 Nov 15 2001 equipos.frm -rw-rw---- 1 mysql mysql 6230 Nov 27 12:31 equipos.MYD -rw-rw---- 1 mysql mysql 2048 Nov 27 12:31 equipos.MYI -rw-rw---- 1 mysql mysql 8736 Nov 26 2001 medicioneq.frm -rw-rw---- 1 mysql mysql 78553663 Nov 27 12:33 medicioneq.MYD -rw-rw---- 1 mysql mysql 66780160 Nov 27 12:33 medicioneq.MYI -rw-rw---- 1 mysql mysql 8730 Nov 19 2001 medicionproc.frm -rw-rw---- 1 mysql mysql 82973949952 Nov 27 12:33 medicionproc.MYD -rw-rw---- 1 mysql mysql 16107317248 Dec 3 00:36 medicionproc.MYI -rw-rw---- 1 mysql mysql 8606 Jun 13 16:32 muestra.frm -rw-rw---- 1 mysql mysql 57143142 Nov 27 15:33 muestra.MYD -rw-rw---- 1 mysql mysql 189243392 Dec 2 15:07 muestra.MYI -rw-r--r-- 1 root other 882 Jan 24 2002 nohup.out -rw-rw---- 1 mysql mysql 8788 Sep 24 17:12 pepito.frm -rw-rw---- 1 mysql mysql 6230 Sep 24 17:12 pepito.MYD -rw-rw---- 1 mysql mysql 1024 Sep 24 17:12 pepito.MYI -rw-r--r-- 1 root other 1181732 May 15 2002 salida.iwserver If I could get the table structure I would drop it and create it again, becuase I can lost the data the most importan to me is to have the table available Thanks La información contenida en este correo es para uso exclusivo de los destinatarios del mismo. Está prohibido a las personas o entidades que no sean los destinatarios de este correo, realizar cualquier tipo de modificación, copia o distribución del mismo. Si Ud. recibe este correo por error, tenga a bien notificar al emisor y eliminarlo. This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Personal. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please contact the sender.(Embedded image moved to file: pic25722.pcx)
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
