windows禅道数据迁移到Linux禅道数据库数据提示损坏已解决 悬赏5积分
迁移数据重新启动服务成功后,访问页面一直白屏。
查看数据库日志,提示:
root@dell-PowerEdge-R750:/opt/zbox/data/mysql# tail /opt/zbox/logs/mysql_error.log
2025-01-10 14:54:50 14 [ERROR] InnoDB: Table zentao
.`zt_workflowui` is corrupted. Please drop the table and recreate.
2025-01-10 14:54:50 14 [ERROR] InnoDB: Table zentao
.`zt_workflowversion` is corrupted. Please drop the table and recreate.
2025-01-10 14:54:50 14 [ERROR] InnoDB: Table zentao
.`zt_zoutput` is corrupted. Please drop the table and recreate.
2025-01-10 14:54:50 18 [ERROR] InnoDB: Table zentao
.`zt_config` is corrupted. Please drop the table and recreate.
2025-01-10 14:54:58 19 [ERROR] InnoDB: Table zentao
.`zt_config` is corrupted. Please drop the table and recreate.
2025-01-10 14:55:50 20 [ERROR] InnoDB: Table zentao
.`zt_config` is corrupted. Please drop the table and recreate.
2025-01-10 14:56:50 21 [ERROR] InnoDB: Table zentao
.`zt_config` is corrupted. Please drop the table and recreate.
2025-01-10 14:57:50 22 [ERROR] InnoDB: Table zentao
.`zt_config` is corrupted. Please drop the table and recreate.
2025-01-10 14:58:50 23 [ERROR] InnoDB: Table zentao
.`zt_config` is corrupted. Please drop the table and recreate.
2025-01-10 14:59:50 24 [ERROR] InnoDB: Table zentao
.`zt_config` is corrupted. Please drop the table and recreate.
禅道版本:禅道开源版 21.2
安装包类型:Linux安装包
操作系统:Ubuntu
客户端浏览器:
🎂 windows的数据库备份建议使用mysqldump 命令进行备份,然后到Linux数据库里source 导入即可。因为如果直接拷贝文件,系统未关闭的情况可能会导致文件不完整。
回复
|