forum.lissyara.su

Код: Выделить всё

zg# mysql -e 'select * from mysql.proc'
zg# mysql -e 'drop table mysql.proc'
zg# mysql -e 'select * from mysql.proc'
ERROR 1146 (42S02) at line 1: Table 'mysql.proc' doesn't exist
zg# mysql_upgrade --force
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck'...
Running 'mysqlcheck'...
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
test.dup_names                                     OK
test.unique_names                                  OK
Running 'mysql_fix_privilege_tables'...
OK
zg# mysql -e 'select * from mysql.proc'
zg#

Код: Выделить всё

mysql.time_zone
error    : Table upgrade required. Please do "REPAIR TABLE `time_zone`" to fix i                                                          t!
mysql.time_zone_leap_second
error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_leap_secon                                                          d`" to fix it!
mysql.time_zone_name
error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" to                                                           fix it!
mysql.time_zone_transition
error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition                                                          `" to fix it!
mysql.time_zone_transition_type
error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition                                                          _type`" to fix it!
mysql.user
error    : Table upgrade required. Please do "REPAIR TABLE `user`" to fix it!
roundcubedb.cache
error    : Table upgrade required. Please do "REPAIR TABLE `cache`" to fix it!
roundcubedb.contacts
error    : Table upgrade required. Please do "REPAIR TABLE `contacts`" to fix it                                                          !
roundcubedb.identities
error    : Table upgrade required. Please do "REPAIR TABLE `identities`" to fix                                                           it!
roundcubedb.messages
error    : Table upgrade required. Please do "REPAIR TABLE `messages`" to fix it                                                          !
roundcubedb.session
error    : Table upgrade required. Please do "REPAIR TABLE `session`" to fix it!
roundcubedb.users
error    : Table upgrade required. Please do "REPAIR TABLE `users`" to fix it!

Repairing tables
FATAL ERROR: Upgrade failed