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

DB will not import, several errors

Discussion in 'Server Configuration and Hosting' started by Solidus, Sep 15, 2013.

  1. Solidus

    Solidus Well-Known Member

    I am trying to import an XF database on another server, and I am having issues.
    In PHPMyAdmin, I get the "Got a packet bigger than 'max_allowed_packet' bytes" error, even after trying values of 2-2000mb. I also get incorrect syntax errors too.
    When I import using ssh, it stops every time when importing xf_data_registry table, on column 23 which is styles. There are 3 styles installed, after I deleted files from FTP and dropped tables from xf_styles.

    Question: Can I safely drop xf_data_registry and it will rebuild correctly?
    Any suggestions appreciated.
  2. RoldanLT

    RoldanLT Well-Known Member

  3. borbole

    borbole Well-Known Member

    Alternatively try mysqldumper too. It handles both actions, backup and restore with ease. And for large files too.
  4. Solidus

    Solidus Well-Known Member

    How will this differ form importing in ssh?

    mysql -p -u username database_name < file.sql
    ^ I've tried this way, still aborts at styles in xf_data_registry
  5. RoldanLT

    RoldanLT Well-Known Member

    You can select option"FORCE" to ignore such error.
    What about: mysql -p -u username database_name < file.sql -f
    Solidus likes this.
  6. Solidus

    Solidus Well-Known Member

    Trying that now.
  7. Solidus

    Solidus Well-Known Member

    Works. :) Thank you.

Share This Page