堡塔618特惠活动,企业版1099元/年,永久授权最高立减20000元查看活动
当前位置:论坛首页 > Linux面板 > 求助

【待反馈】数据库导入失败

发表在 Linux面板2023-7-25 06:02 [复制链接] 2 746

为了能快速了解并处理您的问题,请提供以下基础信息:2023-07-24T21:56:11.591335Z 282 [ERROR] InnoDB: Cannot create file './chat/user.ibd'
2023-07-24T21:56:11.591340Z 282 [ERROR] InnoDB: The file './chat/user.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file './chat/user.ibd' under the 'datadir' of MySQL.
2023-07-24T21:56:11.611057Z 282 [ERROR] InnoDB: Operating system error number 17 in a file operation.
2023-07-24T21:56:11.611077Z 282 [ERROR] InnoDB: Error number 17 means 'File exists'
2023-07-24T21:56:11.611082Z 282 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2023-07-24T21:56:11.611087Z 282 [ERROR] InnoDB: Cannot create file './chat/withdrawal_record.ibd'
2023-07-24T21:56:11.611092Z 282 [ERROR] InnoDB: The file './chat/withdrawal_record.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file './chat/withdrawal_record.ibd' under the 'datadir' of MySQL.


请问我要如何解决这个问题
使用道具 举报 只看该作者 回复
发表于 2023-7-25 06:25:22 | 显示全部楼层
删除ibd文件后再次导入还是存在这个问题
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急问题处理

论坛响应时间:10分钟

问题处理方式:1对1处理(优先)

工作时间:白班:9:00 - 18:00

工作时间:晚班:18:00 - 24:00

立即付费处理

工作时间:09:00至24:00

快速回复 返回顶部 返回列表