• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

DB import error and stops.

#1
Hi ..

Under importing of my dev db to new db I got the following error:

Code:
[Err] [Dtf] 1153 - Got a packet bigger than 'max_allowed_packet' bytes With statement: INSERT INTO `xf_admin_template` VALUES ('446', 'page_delete', '<xen:title>{xen:phrase confirm_deletion_of_page}: {$page.title}</xen:title>\n<xen:h1>{xen:phrase confirm_deletion_of_page}</xen:h1>\n\n<xen:navigation>\n    <xen:breadcrumb href=\"{xen:adminlink \'pages/edit\', $page}\">{$page.title}</xen:breadcrumb>\n</xen:navigation>\n\n<xen:require css=\"delete_confirmation.css\" />\n\n<xen:form action=\"{xen:adminlink \'pages/delete\', $page}\" class=\"deleteConfirmForm formOverlay\">\n\n    <p>{xen:phrase please_confirm_that_you_want_to_delete_following_page}:</p>\n    <strong><a href=\"{xen:adminlink \'pages/edit\', $page}\">{$page.title}</a></strong>\n\n    <xen:include template=\"helper_node_delete_children\" />\n\n    <xen:submitunit save=\"{xen:phrase delete_page}\" />\n    <input type=\"hidden\" name=\"_xfConfirm\" value=\"1\" />\n    \n</xen:form>', 0x613A393A7B693A303B613A353A7B733A343A2274797065223B733A333A22544147223B733A343A226E616D65223B733A353A227469746C65223B733A31303A2261747472696275746573223B613A303A7B7D733A343A226C696E65223B693A313B733A383A226368696C6472656E223B613A333A7B693A303B613A343A7B733A343A2274797065223B733A31343A224355524C595F46554E4354494F4E223B733A343A226E616D65223B733A363A22706872617365223B733A393A22617267756D656E7473223B613A313A7B693A303B733A32343A22636F6E6669726D5F64656C6574696F6E5F6F665F70616765223B7D733A343A226C696E65223B693A313B7D693A313B733A323A223A20223B693A323B613A343A7B733A343A2274797065223B733A393A224355524C595F564152223B733A343A226E616D65223B733A343A2270616765223B733A343A226B657973223B613A313A7B693A303B733A353A227469746C65223B7D733A343A226C696E65223B693A313B7D7D7D693A313B733A313A220A223B693A323B613A353A7B733A343A2274797065223B733A333A22544147223B733A343A226E616D65223B733A323A226831223B733A31303A2261747472696275746573223B613A303A7B7D733A343A226C696E65223B693A323B733A383A226368696C6472656E223B613A313A7B693A303B613A343A7B733A343A2274797065223B733A31343A224355524C595F46554E4354494F4E223B733A343A226E616D65223B733A363A22706872617365223B733A393A22617267756D656E7473223B613A313A7B693A303B733A32343A22636F6E6669726D5F64656C6574696F6E5F6F665F70616765223B7D733A343A226C696E65223B693A323B7D7D7D693A333B733A323A220A0A223B693A343B613A353A7B733A343A2274797065223B733A333A22544147223B733A343A226E616D65223B733A31303A226E617669676174696F6E223B733A31303A2261747472696275746573223B613A303A7B7D733A343A226C696E65223B693A343B733A383A226368696C6472656E223B613A333A7B693A303B733A323A220A09223B693A313B613A353A7B733A343A2274797065223B733A333A22544147223B733A343A226E616D65223B733A31303A2262726561646372756D62223B733A31303A2261747472696275746573223B613A313A7B733A343A2268726566223B613A313A7B693A303B613A343A7B733A343A2274797065223B733A31343A224355524C595F46554E4354494F4E223B733A343A226E616D65223B733A393A2261646D696E6C696E6B223B733A393A22617267756D656E7473223B613A323A7B693A303B613A313A7B693A303B733A31303A2270616765732F65646974223B7D693A313B613A343A7B733A343A2274797065223B733A393A224355524C595F564152223B733A343A226E616D65223B733A343A2270616765223B733A343A226B657973223B613A303A7B7D733A343A226C696E65223B693A353B7D7D733A343A226C696E65223B693A353B7D7D7D733A343A226C696E65223B693A353B733A383A226368696C6472656E223B613A313A7B693A303B613A343A7B733A343A2274797065223B733A393A224355524C595F564152223B733A343A226E616D65223B733A343A2270616765223B733A343A226B657973223B613A313A7B693A303B733A353A227469746C65223B7D733A343A226C696E65223B693A353B7D7D7D693A323B733A313A220A223B7D7D693A353B733A323A220A0A223B693A363B613A353A7B733A343A2274797065223B733A333A22544147223B733A343A226E616D65223B733A373A2272657175697265223B733A31303A2261747472696275746573223B613A313A7B733A333A22637373223B613A313A7B693A303B733A32333A2264656C6574655F636F6E6669726D6174696F6E2E637373223B7D7D733A343A226C696E65223B693A383B733A383A226368696C6472656E223B613A303A7B7D7D693A373B733A323A220A0A223B693A383B613A353A7B733A343A2274797065223B733A333A22544147223B733A343A226E616D65223B733A343A22666F726D223B733A31303A2261747472696275746573223B613A323A7B733A363A22616374696F6E223B613A313A7B693A303B613A343A7B733A343A2274797065223
[Err] [Dtf] Finished - Unsuccessfully
How to continue from here? Can I manually delete this record and other similar?
 
#2
Ok ..

What should max_allowed_packet=xxx MB in MySQL be set to? ..

EDIT: Have defined max_allowed_packet=512MB - Restarted MySQL and now it importing DB..

I dont know what is best practice nor if I must set that value after some table size..
 

Mike

XenForo developer
Staff member
#3
It really depends on various export options, but in general, your target DB server's max_allowed_packet must be as big (or bigger than) the source server's value.
 
#4
It really depends on various export options, but in general, your target DB server's max_allowed_packet must be as big (or bigger than) the source server's value.
Its the same db server - same panel - but different domain and login .. So I dont understand this with the source/target value as it is the same db server.

But nevermind - I got my db data imported.. And thats the point for now
so I can continue.. Thanks for answer anyway Mike..