Alex had written me back at about 2am in the morning (gosh!) and told us to run:
It sounds like your mysql tables are corrupted. You should:
1. Shut down MySQL. 2. cd to the mysql database directory 3. Run as root: myisamchk -r *.MYI 4. Start up MySQL
and your indexes should be repaired and things back in shape.
That worked just dandy! Lesson being that I should have done it immediately after doing a large purge of users. Since we are on a fully managed server, it required Root.
But now I have a whole bunch of popbox.0000.bak files... about 300 of them that I need to run thru incoming.pl. How do you recommend we do this so we can get everyone their email when the system wasn't processing?
Thanks!
Diversity by Design
Quote:
It sounds like your mysql tables are corrupted. You should:
1. Shut down MySQL. 2. cd to the mysql database directory 3. Run as root: myisamchk -r *.MYI 4. Start up MySQL
and your indexes should be repaired and things back in shape.
That worked just dandy! Lesson being that I should have done it immediately after doing a large purge of users. Since we are on a fully managed server, it required Root.
But now I have a whole bunch of popbox.0000.bak files... about 300 of them that I need to run thru incoming.pl. How do you recommend we do this so we can get everyone their email when the system wasn't processing?
Thanks!
Diversity by Design