1. 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.

Discussion in 'Installation, Upgrade, and Import Support' started by BlackMuddler, Feb 23, 2011.

  1. BlackMuddler

    BlackMuddler Active Member

    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. BlackMuddler

    BlackMuddler Active Member

    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..
     
  3. Mike

    Mike XenForo Developer Staff Member

    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. BlackMuddler

    BlackMuddler Active Member

    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 [​IMG] so I can continue.. Thanks for answer anyway Mike..
     

Share This Page