Running a FreeBSD system and mysql 5.0.27 server, I recently upgraded to
5.0.51 (but kept the 5.0.27 client). Everything seemed fine, until I ran a
databse check today:
Checking information_schema:CHARACTER_SETS Checking
information_schema:COLLATIONS Checking
information_schema:COLLATION_CHARACTER_SET_APPLICABILITY
Checking information_schema:COLUMNS
ERROR, REPAIR could not execute
Checking information_schema:COLUMN_PRIVILEGES
Checking information_schema:KEY_COLUMN_USAGE
Checking information_schema:PROFILING
Checking information_schema:ROUTINES
ERROR, REPAIR could not execute
Checking information_schema:SCHEMATA
Checking information_schema:SCHEMA_PRIVILEGES
Checking information_schema:STATISTICS
Checking information_schema:TABLES
Checking information_schema:TABLE_CONSTRAINTS
Checking information_schema:TABLE_PRIVILEGES
Checking information_schema:TRIGGERS
ERROR, REPAIR could not execute
Checking information_schema:USER_PRIVILEGES
Checking information_schema:VIEWS
ERROR, REPAIR could not execute
Oops! How can I fix these information_schema errors?? I ran a full:
/usr/local/bin/myisamchk --force --extend-check --update-state -O
key_buffer=128M -O sort_buffer=128M -O read_buffer=2M -O write_buffer=2M
/var/db/mysql/*/*.MYI
But that didn't seem to include the information_schema, though. How can I
fix these errors? So close to Xmax, I'm panicking a little.
Thanks,
- Mark