I can't upload my entire MyBB database - error 1153 max_allowed_packet

[ctccoco]

When I try to upload my MyBB database I can't because I get this error through phpmyadmin:

#1153 - Got a packet bigger than 'max_allowed_packet' bytes

Please, somebody can help me? I can't use anything else because external MySQL access is not allowed.

The website is slaverebellion.x10.mx (user slavereb).

Thanks.

 

[garrettroyce]

Divide the backup file into multiple smaller files.

Generally, backups are divided into many sections:

Section 1: Database structure (CREATE TABLE... ) queries.

Section 2 ... #####: INSERTing records into each table (INSERT INTO some_table ...). Each table is usually divided into its own section by commends (# SOME COMMENT)

I would divide up each section into its own file, then upload them all. Section 1 must be first, the other sections are arbitrary.

If a section gives the same error, divide it into smaller pieces again.