导致“备份文件中的未知对象"的原因是什么?还原MySQL数据库的备份时出现问题? [英] What would lead to an "Unknown object in backup file" problem when restoring a backup of a MySQL database?

问题描述

不幸的是，问题并不比这更具体.我发现有人通过做

Unfortunately, the problem is not more specific than that. I've found a few examples of people reporting similar problems by doing a Google search, but I can't find the part of the restore that is actually causing the problem, which might help me track it down on my own.

对于解决此问题或能够找到根本原因的建议，我们将不胜感激.

Suggestions for either resolving this problem or being able to track down the root cause would be appreciated.

推荐答案

在bugs.mysql.com上记录了一个错误，该错误引用了您描述的错误:

There's one bug logged at bugs.mysql.com that references the error you describe:

"错误#37253无法还原包含BLOB的备份文件"

该错误中描述的解决方案是增加MySQL服务器配置中的max_allowed_packet.用户确认将值提高到100M可以恢复数据库.

The solution described in that bug is to increase the max_allowed_packet in the MySQL server configuration. The user confirmed that raising the value to 100M allowed him to restore his database.

这篇关于导致“备份文件中的未知对象"的原因是什么?还原MySQL数据库的备份时出现问题?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！