Unknown object in backup file in MySQL 5.1.41-3 ubuntu12.10

Question

I am restoring mysql backup file which is of size 2.6GB...but while restoring I am getting "Unknown object in backup file" exception . How can i solve this problem. and there are no logs in mysql administrator.

Thanks,

score 0 · Answer 1 · edited May 23 '17 at 10:09

0

Seems similar to the post on SO

The solution described in that bug is to increase the max_allowed_packet in the MySQL server configuration.

edited May 23 '17 at 10:09

Community

1
1

answered Jul 23 '12 at 08:47

jsist

5,223
3
28
43

i increased the max_allowed_packet size to 1024M but problem remains same in ubuntu. – pbhle Jul 23 '12 at 09:11
Do you have any BLOB field in your tables? – jsist Jul 23 '12 at 09:26
There are many other solutions as well given in the SO link. read it fully, may be your problem will be solved through some of those... – jsist Jul 23 '12 at 09:30
Did you restarted your MySQL server again after changing the value? – jsist Jul 23 '12 at 09:32
yes i have blob fields in my tables. also i have restarted my mysql after increasing packet size. – pbhle Jul 23 '12 at 09:37

Unknown object in backup file in MySQL 5.1.41-3 ubuntu12.10

1 Answers1