MyISAM表的损坏恢复以及myisamchk工具使用

set  default_storage_engine=MyISAM； 创建一个表 create table shop (id int,name varchar(20),price float(5,2),city varchar(20),street varchar(20),riqi date); insert into shop values(1001,".1 niu1",5.99,"shenyang","sanhaojie","2021-04-02"); insert into shop values(1002,".2 niu1",5.99,"shenyang","sanhaojie","2020-04-08"); insert into shop values(1003,".3 niu3",9.99,"shenyang","sanhaojie","2015-07-15"); 模拟MyISAM表损坏 myisamchk修复 检查表  myisamchk -im /var/lib/mysql/backup/t1  仅显示表的最重要的信息 [root@localhost backup]# myisamchk  -eis /var/lib/mysql/backup/t1