Confluence using MySQL Plugin Export/Import Problem

[Thomas Petersen]

So I'm having a problem: I exported my DB save for the PLUGINDATA table and imported it just fine. I've been having a problem reimporting the plugins themselves..

[root@randomserver zipp]# mysql --max_allowed_packet=1024M confluence < confluence.plugindata.sql

ERROR 1153 (08S01) at line 44: Got a packet bigger than 'max_allowed_packet' bytes

Any suggestions? The dump file itself is only 48M

-rw-r--r-- 1 zipp users 48M Aug 3 14:37 confluence.plugindata.sql

[Sergey Markovich]

Hi Thomas,

Have you set max_allowed_packet on MySQL server side too? When you set --max_allowed_packet=1024M parameter that is for MySQL client only. To change it on server change the my.cnf or my.ini file under the mysqld section and set max_allowed_packet=100M

You can also run these commands in a mysql console connected to that same server:

set global net_buffer_length=1000000;

set global max_allowed_packet=1000000000;

[Thomas Petersen]

I opened up two consoles and had already tried those set commands and ended up getting the same error. Only thing I haven't done yet is trying to chunk the file? It's a 48M file so I see no reason it can't buffer this thing.

[Thomas Petersen]

Got it. Had to resize max_allowed_packet in my.cnf and restart mysqld.