myisamchk is another option
see 4.4.6 Using myisamchk for Table Maintenance and Crash Recovery in the mysql manual ----- Original Message ----- From: "Cecil Brand" <[EMAIL PROTECTED]> To: "<" <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 10:30 AM Subject: Rebuilding Indexs on tables > Hi, > > I was wandering is there an easy way to rebuild indexs on tables > I have the .frm and .MYD files. > > I read in the mysql manuals about backup_tables and Restore_table that > rebuild the index but > is there any other way to rebuild them. > > I'm using Mysql 3.23.53a > on linux 2.1 AS > > thx > > Cecil > > Mnr Cecil J.C. Brand > Internet Office > RekenaarDienste > University of the Free State/ > Universiteit van die Vrystaat > PO Box 339 > Bloemfontein 9300 > South Africa > > Tel :401 2645 > Email :[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]