Hi The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36, the standard RedHat version.
The machine is running two databases, one is a full archive while the other ones holds current data. The same five records are unavailable using SQL in the two databases, but using mysqldump I can see the records. Obviously the data file is OK, but the index records are corrupt. What can I do ? - Export the databases, drop originals and reload. - Drop indexes and rebuild ? - Repair files ? Which ones, data or index or both ? What is advisable and will involve the least work ? Simon On Monday 12 November 2001 5:20 pm, Simon Windsor wrote: > Hi > > I appear to have lost several records, but on doing mysqldump <db> the > records are there. > > I have tried optimize|repair and the data hasn't re-appeared. > > Any ideas ? > > Simon > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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