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