David Churches wrote: > Hi, > > I am using mySQL version 3.23.52 and I have tried to create an index on a > large table. This was taking a very long time and so the command was > terminated. Now the database seems to be corrupted, or at least > inaccessible. Is there anything I can do? > > I have tried mysqlcheck but it seems to be taking a very long time too. > > Thanks in advance for any help you can give, > > Dave. > > ------------------------------------------------------------- > David Churches > Department of Physics and Astronomy > Cardiff University, 5 The Parade, Cardiff, CF24 3YB, U.K. > Phone: + 44-29-20874785, 20875120 (direct line) Fax: + 44-29-20874056 > [EMAIL PROTECTED] > > --------------------------------------------------------------------- > 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
David, Check the archives. There was some discussion on this earlier this week. Here is some info from one of the discussions. "Also, use "myisamchk -dv tablename" Pay attention to datafile pointer (bytes) and Keyfile pointer (bytes) and the Max keyfile/datafile length. The keyfile pointer must be at least 4 bytes for a large table, if it says 3 you have a problem! This is isn't clear from the CREATE TABLE section of the manual, but is in the "1.2.4 How Big Can MySQL Tables Be?". I don't know if there is any problem or change like this need for InnoDB, since Innodb is not mentioned I would suspect it is not needed." walt --------------------------------------------------------------------- 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
