Hi Stanley, You also have the options to indicates mysqld to checks and repairs tables automatically as it detects corruption or crash. Put in the section mysqld of your my.cnf file these 2 variables : first: set-variable = myisam-recover=BACKUP,FORCE (it will try to do 'safe' repair, otherwise make a backup of problematic table and a force repair) second: set-variable = myisam_sort_buffer_size=4M (if you have enough memory, use greater value; this accelerates the process of repair).
The automatic check and/or repair will leave a message in the .err file to indicates that a corruption or crash has occurs. PS: Try it with version 4.0.x Hope; this resolves Thierno6C :MySQL 4.0.15 ----- Original Message ----- From: "Alexis da Cruz Henriques Guia" <[EMAIL PROTECTED]> To: "Stanley Joseph" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 06, 2003 5:31 PM Subject: Re: MYSQL table crashed and doesn't repair > > Execute in shell myisamchk --help > > This will list a serie of options to repair your tables. Obviously, this only > works to MyISAM tables. > > ;) > Alexis > > Quoting Stanley Joseph <[EMAIL PROTECTED]>: > > > Dear All , > > A few tables of my database crashed and are not getting repaired .What is > > the best way to recover the data . > > Any suggestion will be of great help . > > > > Regards > > > > Stanley Joseph > > > > +44 (0) 208 665 4291 (W) > > +44 (0) 777 621 0132 (M) > > http://www.themobilerepublic.com > > The Price, The Choice, The Service > > > > This email and any attachments are confidential. They may contain privileged > > information and are intended for the named addressee(s) only. They must not > > be distributed without our consent. If you are not the intended recipient, > > please notify us immediately and do not disclose, distribute, or retain this > > email or any part of it. Unless expressly stated, opinions in this email are > > those of the individual sender, and not of The Mobile Republic. We believe > > but do not warrant that this e-mail and any attachments are virus free. You > > must therefore take full responsibility for virus checking. The Mobile > > Republic and its subsidiaries reserve the right to monitor all email > > communications through their networks. > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
