2006 MySQL error

  • Resolved tadejf

    (@tadejf)


    1 year, 7 months ago

    My import always stops at 30% and it throws the following msg: “[ERROR] Error:SQLSTATE[HY000]: General error: 2006 MySQL server has gone away”

    Up to that point the users and other data were migrated successfully. I am using the premium version and the Commerce Add-On.

    This is the printscreen: https://tinyurl.com/289zx8jk

    Can you please help me out? Thanks!

Viewing 1 replies (of 1 total)
  • Plugin Author Kerfred

    (@kerfred)

    If you have access to the mySQL config file (my.cnf or my.ini), add these lines in the config file and restart MySQL:

    max_allowed_packet=512M
    wait_timeout=28800

    If not, run these SQL commands on phpMyAdmin on the WordPress database before doing the import:

    SET GLOBAL max_allowed_packet=524288000;
    SET GLOBAL wait_timeout=28800;

    Please also note that this forum is reserved for the free version only. If you have any question concerning the Premium version or the add-ons, please contact our support team at https://www.fredericgilles.net/support/

Viewing 1 replies (of 1 total)
  • The topic ‘2006 MySQL error’ is closed to new replies.