RE: Database Catastrophe

2002-04-02 Thread MySQL
[EMAIL PROTECTED] writes: >Not sure what to tell you - check to see if you have logging enabled on your Logging is not enabled. > >This is a longshot, but you might have had a corrupted index that >inaccurately reported 75k records when you really were only at 13k, and >optimizing the table did s

Database Catastrophe

2002-04-02 Thread MySQL
Folks, The database I setup 2 weeks ago was operating fine, if a bit slow. Yesterday, I tried running the OPTIMIZE TABLE command on it, as recommended on this list for improving performance. Yesterday there were 75,000 records in my database. Today, there are 13,000 records. Apart from the Op