DB will not import, several errors


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.


Well-known member
Alternatively try mysqldumper too. It handles both actions, backup and restore with ease. And for large files too.