dock logs -f mysql 查看日志后发现
InnoDB: Error: page 7 log sequence number 76214539679
InnoDB: is in the future! Current system log sequence number 104795834.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
在mysql的配置文件my.cnf里找到 [mysqld]字段下,添加 innodb_force_recovery=6
这时可以正常访问mysql
方法一:用mysqldump将里面的表备份,重装mysql,再导入
方法二:将挂载的/data目录中的表信息进行备份,删除后重新创建容器并挂载,将备份的数据导入