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
