linux版mysql5.6默认innodb表损坏
希望管理员能解决解决啊。。。。欲哭无泪进入ssh 查看是否存在“innodb_tables_stats”
ls /www/server/data/mysql
存在的话执行以下命令 删除 并执行下方的SQL语句
rm -f /www/server/data/mysql innodb_table_stats*不存在的话直接执行sql语句
CREATE TABLE `innodb_table_stats` (
`database_name` varchar(64) COLLATE utf8_bin NOT NULL,
`table_name` varchar(64) COLLATE utf8_bin NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`n_rows` bigint(20) unsigned NOT NULL,
`clustered_index_size` bigint(20) unsigned NOT NULL,
`sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`database_name`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
页:
[1]