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.
对于解决此问题或能够追踪根本原因的建议将不胜感激。
3 个解决方案
#1
4
There's one bug logged at bugs.mysql.com that references the error you describe:
在bugs.mysql.com上记录了一个错误,它引用了您描述的错误:
"Bug #37253 Unable to restore backup file containing BLOBs"
“Bug#37253无法恢复包含BLOB的备份文件”
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.
该bug中描述的解决方案是增加MySQL服务器配置中的max_allowed_packet。用户确认将值提高到100M允许他恢复他的数据库。
#2
4
ANOTHER FIX
I also had this problem! The answers online didn't seem to help (max_allowed_packet and others)
我也有这个问题!在线答案似乎没有帮助(max_allowed_packet和其他人)
Here's what fixed mine:
这是固定我的:
Instead of running the Restore function, I imported through MySQL Migration Toolkit (installed with GUI Tools on Windows).
我没有运行Restore功能,而是通过MySQL Migration Toolkit导入(在Windows上安装了GUI Tools)。
The Migration Toolkit also failed, but had descriptive errors in the Log on the final page. In my case, it was a few incorrect Date fields in my data (usually "0000-00-00") that wouldn't migrate correctly.
迁移工具包也失败了,但在最终页面的登录中有描述性错误。就我而言,我的数据(通常是“0000-00-00”)中的一些不正确的日期字段无法正确迁移。
Fixing these dates in my tables solved the Restore problem.
在我的表中修复这些日期解决了Restore问题。
Hope this helps somebody else out there.
希望这有助于其他人。
#3
0
I have had something similar in the past- it has something to do with how it was backed up. I think some applications put invalid comments in the backup files which cause errors.
我过去曾经有过类似的东西 - 它与备份的方式有关。我认为有些应用程序会在备份文件中放入无效注释,从而导致错误。
My suggestion- if you are stuck trying to restore those files- is to incrementally start backing up from sections of the backup file and find what is causing the problems- which from what I recall the case for me was that they were some text in the file that was inconsequential to remove.
我的建议 - 如果你*试图恢复这些文件 - 是逐步开始从备份文件的各个部分开始备份,并找到导致问题的原因 - 我记得我的情况是,他们是一些文本在删除无关紧要的文件。
#1
4
There's one bug logged at bugs.mysql.com that references the error you describe:
在bugs.mysql.com上记录了一个错误,它引用了您描述的错误:
"Bug #37253 Unable to restore backup file containing BLOBs"
“Bug#37253无法恢复包含BLOB的备份文件”
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.
该bug中描述的解决方案是增加MySQL服务器配置中的max_allowed_packet。用户确认将值提高到100M允许他恢复他的数据库。
#2
4
ANOTHER FIX
I also had this problem! The answers online didn't seem to help (max_allowed_packet and others)
我也有这个问题!在线答案似乎没有帮助(max_allowed_packet和其他人)
Here's what fixed mine:
这是固定我的:
Instead of running the Restore function, I imported through MySQL Migration Toolkit (installed with GUI Tools on Windows).
我没有运行Restore功能,而是通过MySQL Migration Toolkit导入(在Windows上安装了GUI Tools)。
The Migration Toolkit also failed, but had descriptive errors in the Log on the final page. In my case, it was a few incorrect Date fields in my data (usually "0000-00-00") that wouldn't migrate correctly.
迁移工具包也失败了,但在最终页面的登录中有描述性错误。就我而言,我的数据(通常是“0000-00-00”)中的一些不正确的日期字段无法正确迁移。
Fixing these dates in my tables solved the Restore problem.
在我的表中修复这些日期解决了Restore问题。
Hope this helps somebody else out there.
希望这有助于其他人。
#3
0
I have had something similar in the past- it has something to do with how it was backed up. I think some applications put invalid comments in the backup files which cause errors.
我过去曾经有过类似的东西 - 它与备份的方式有关。我认为有些应用程序会在备份文件中放入无效注释,从而导致错误。
My suggestion- if you are stuck trying to restore those files- is to incrementally start backing up from sections of the backup file and find what is causing the problems- which from what I recall the case for me was that they were some text in the file that was inconsequential to remove.
我的建议 - 如果你*试图恢复这些文件 - 是逐步开始从备份文件的各个部分开始备份,并找到导致问题的原因 - 我记得我的情况是,他们是一些文本在删除无关紧要的文件。