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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69990629/viewspace-3093383/ ，如需转载，请注明出处，否则将追究法律责任。
