fisher писал(а):Код: Выделить всё
mysql> select * from mdk_m4; select * from mdk_m4_sensor; select * from mdk_m5t; select * from sensor;
ERROR 130 (HY000): Incorrect file format 'mdk_m4'
ERROR 130 (HY000): Incorrect file format 'mdk_m4_sensor'
ERROR 130 (HY000): Incorrect file format 'mdk_m5t'
ERROR 130 (HY000): Incorrect file format 'sensor'
Вот такую беду нашёл после сбоя системы из-за нехватки места на разделе.
REPAIR TABLE не помогает.
Бекап всей БД боюсь тоже не сильно поможет, последний делался достаточно давно и там mdk_m4 не наблюдается, как и mdk_m5t
CREATE TABLE `technology`.`mdk_m4` (
`id` varchar(128) NOT NULL,
`location` varchar(128) DEFAULT NULL,
`responsible` varchar(128) DEFAULT NULL,
`contacts` varchar(128) DEFAULT NULL,
`id_station` int(10) unsigned NOT NULL,
`id_group` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `technology`.`mdk_m4_sensor` (
`id` int(10) unsigned NOT NULL,
`id_parent` varchar(128) NOT NULL,
`id_channel` varchar(128) DEFAULT NULL,
`num` int(10) unsigned NOT NULL,
`id_group` int(10) unsigned DEFAULT '0',
`type` int(10) unsigned DEFAULT '0',
`name` varchar(128) DEFAULT NULL,
`desc` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `technology`.`mdk_m5t` (
`id` varchar(128) NOT NULL,
`location` varchar(128) DEFAULT NULL,
`responsible` varchar(128) DEFAULT NULL,
`contacts` varchar(128) DEFAULT NULL,
`id_station` int(10) unsigned NOT NULL,
`id_group` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `technology`.`sensor` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`x` int(10) unsigned NOT NULL,
`y` int(10) unsigned NOT NULL,
`id_office` int(10) unsigned NOT NULL,
`id_room` int(10) unsigned NOT NULL,
`type` int(10) unsigned NOT NULL,
`description` varchar(256) DEFAULT NULL,
`href` varchar(45) DEFAULT NULL,
`id_group` int(10) unsigned NOT NULL,
`view` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;