Всем привет!
Debian 6 сервер. На нем MariaDB (mysql)
Постоянно при рестарте (старте) выпадает вот это.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Перепробовал уже все советы, что в нэте нашел
Например
mysqlcheck --check-upgrade --all-databases --auto-repair -u root -p
mysql_upgrade --force -u root -p
Там везде OK
cat /var/log/mysql/mysql.log
/usr/sbin/mysqld, Version: 5.2.7-MariaDB-mariadb101~squeeze-log ((MariaDB - http://mariadb.com/)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
110728 18:17:01 1 Connect debian-sys-maint@localhost as anonymous on
1 Quit
2 Connect debian-sys-maint@localhost as anonymous on
2 Quit
3 Connect debian-sys-maint@localhost as anonymous on mysql
3 Query select @@version_comment limit 1
3 Query show variables like 'datadir'
3 Quit
4 Connect debian-sys-maint@localhost as anonymous on
4 Query select @@version_comment limit 1
4 Query SELECT count(*) FROM mysql.user WHERE user='root' and password=''
4 Quit
5 Connect debian-sys-maint@localhost as anonymous on
5 Query select @@version_comment limit 1
5 Query select concat('select count(*) into @discard from `',
TABLE_SCHEMA, '`.`', TABLE_NAME, '`')
from information_schema.TABLES where ENGINE='MyISAM'
5 Quit
6 Connect debian-sys-maint@localhost as anonymous on
6 Query select @@version_comment limit 1
6 Query select count(*) into @discard from `mysql`.`columns_priv`
6 Quit
7 Connect debian-sys-maint@localhost as anonymous on
7 Query select @@version_comment limit 1
7 Query select count(*) into @discard from `mysql`.`db`
7 Quit
8 Connect debian-sys-maint@localhost as anonymous on
8 Query select @@version_comment limit 1
8 Query select count(*) into @discard from `mysql`.`event`
8 Quit
9 Connect debian-sys-maint@localhost as anonymous on
9 Query select @@version_comment limit 1
9 Query select count(*) into @discard from `mysql`.`func`
9 Quit
10 Connect debian-sys-maint@localhost as anonymous on
10 Query select @@version_comment limit 1
10 Query select count(*) into @discard from `mysql`.`help_category`
10 Quit
11 Connect debian-sys-maint@localhost as anonymous on
11 Query select @@version_comment limit 1
11 Query select count(*) into @discard from `mysql`.`help_keyword`
11 Quit
12 Connect debian-sys-maint@localhost as anonymous on
12 Query select @@version_comment limit 1
12 Query select count(*) into @discard from `mysql`.`help_relation`
12 Quit
13 Connect debian-sys-maint@localhost as anonymous on
13 Query select @@version_comment limit 1
13 Query select count(*) into @discard from `mysql`.`help_topic`
13 Quit
14 Connect debian-sys-maint@localhost as anonymous on
14 Query select @@version_comment limit 1
14 Query select count(*) into @discard from `mysql`.`host`
14 Quit
15 Connect debian-sys-maint@localhost as anonymous on
15 Query select @@version_comment limit 1
15 Query select count(*) into @discard from `mysql`.`ndb_binlog_index`
15 Quit
16 Connect debian-sys-maint@localhost as anonymous on
16 Query select @@version_comment limit 1
16 Query select count(*) into @discard from `mysql`.`plugin`
16 Quit
17 Connect debian-sys-maint@localhost as anonymous on
17 Query select @@version_comment limit 1
17 Query select count(*) into @discard from `mysql`.`proc`
17 Quit
18 Connect debian-sys-maint@localhost as anonymous on
18 Query select @@version_comment limit 1
18 Query select count(*) into @discard from `mysql`.`procs_priv`
18 Quit
19 Connect debian-sys-maint@localhost as anonymous on
19 Query select @@version_comment limit 1
19 Query select count(*) into @discard from `mysql`.`servers`
19 Quit
20 Connect debian-sys-maint@localhost as anonymous on
20 Query select @@version_comment limit 1
20 Query select count(*) into @discard from `mysql`.`tables_priv`
20 Quit
21 Connect debian-sys-maint@localhost as anonymous on
21 Query select @@version_comment limit 1
21 Query select count(*) into @discard from `mysql`.`time_zone`
21 Quit
22 Connect debian-sys-maint@localhost as anonymous on
22 Query select @@version_comment limit 1
22 Query select count(*) into @discard from `mysql`.`time_zone_leap_second`
22 Quit
23 Connect debian-sys-maint@localhost as anonymous on
23 Query select @@version_comment limit 1
23 Query select count(*) into @discard from `mysql`.`time_zone_name`
23 Quit
24 Connect debian-sys-maint@localhost as anonymous on
24 Query select @@version_comment limit 1
24 Query select count(*) into @discard from `mysql`.`time_zone_transition`
24 Quit
25 Connect debian-sys-maint@localhost as anonymous on
25 Query select @@version_comment limit 1
25 Query select count(*) into @discard from `mysql`.`time_zone_transition_type`
25 Quit
26 Connect debian-sys-maint@localhost as anonymous on
26 Query select @@version_comment limit 1
26 Query select count(*) into @discard from `mysql`.`user`
26 Quit
Ребят, помогите исправить.
Заранее благодарен!