Ok, I'm a little further. I get the error after this command: "CHECK TABLE $table EXTENDED";
Where $table is a table in the information_schema. The specific error seems to be: "Table is already up to date" Instead of the usual: "OK" Could this be related to this? http://lists.mysql.com/internals/31016 Please, shed some light on this! The error does seem less dramatic than I initially thought, but it still freaks me out some. :) - Mark -----Original Message----- From: Mark [mailto:[EMAIL PROTECTED] Sent: zondag 23 december 2007 13:51 To: mysql@lists.mysql.com Subject: information_schema errors after (minor) upgrade 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
