mysql恢复.frm .ibd 的数据 MySQL版本是8.0
1,第一步创建一个数据库，
2,创建表结构
CREATE TABLE bearshop_user (user_id int(11) NOT NULL AUTO_INCREMENT,nickname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,wxaccount varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,mobile varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,avatar varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,openid varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,price decimal(10, 2) NOT NULL DEFAULT 0.00,freezeprice decimal(10, 2) NOT NULL DEFAULT 0.00,signature varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,userintro varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,useredittime int(11) NULL DEFAULT NULL,paypasswd varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,cardname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,cardid varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,access_token varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,contract varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,spoints int(11) NOT NULL DEFAULT 0,upoints int(11) NOT NULL DEFAULT 0,spassword varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,city varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,province varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,country varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,is_company tinyint(1) NULL DEFAULT 0 COMMENT ‘0.未认证 1.已认证’,is_company_type tinyint(1) NULL DEFAULT 0 COMMENT ‘0.个人 1.企业’,company_valid int(11) NULL DEFAULT NULL,qunfa_time varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,qunfa_num tinyint(1) NOT NULL DEFAULT 0,isauth tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘0.未认证 1.认证’,authcode int(5) NOT NULL,subscribe tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘0.未关注 1.已关注’,subscribe_time int(11) NOT NULL,platform_pingbi tinyint(1) NULL DEFAULT 0 COMMENT ‘0.未屏蔽 1.屏蔽’,is_btwoc tinyint(1) NULL DEFAULT 0 COMMENT ‘0.不是 1.是’,recommend_store tinyint(1) NULL DEFAULT 0 COMMENT ‘0.否 1.是’,discoverid int(11) NOT NULL DEFAULT 0,auto_guanzhu tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘0.未自动 1.自动’,ziying tinyint(2) NULL DEFAULT 0,vip_order_sn varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,islock tinyint(2) NULL DEFAULT 0,registrationid varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,gzhopenid varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (user_id) USING BTREE
) ENGINE = INNODB AUTO_INCREMENT=83 DEFAULT ChARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
其中 ENGINE = INNODB AUTO_INCREMENT=83 DEFAULT ChARSET=utf8mb4 ROW_FORMAT=DYNAMIC; 之前到处的再次导入的时候有点问题。所以必须一样。创建表找到文件物理路径，成功进入下一步。
3, 执行 alter table bearshop_user discard tablespace; ibd文件解除绑定。这时候看下数据库文件物理路径 为空了
4，net stop mysql; mysql 停止服务，把备份的 ibd文件 复制到之前的物理路径， net start mysql; mysql 启动服务。
5 alter table bearshop_user IMPORT tablespace; ibd文件绑定. 打开数据库，数据恢复可以了。