DB will not import, several errors

[m1ne]

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.

 

[rdn]

Try: http://sypex.net/en/

 

[borbole]

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

 

[m1ne]

Try: http://sypex.net/en/

How will this differ form importing in ssh?

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

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

 

[rdn]

How will this differ form importing in ssh?

You can select option"FORCE" to ignore such error.

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

What about: mysql -p -u username database_name < file.sql -f

 

[m1ne]

Trying that now.

 

[m1ne]

Works. Thank you.