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

Reply via email to