Hi Richard, Here a quickfix: use max_allow_packet directive directly into your dump command. mysqldump --max_allowed_packet=512m nms_wiki > backup.sql

If you want to understand this more, you should try to change my.cnf, in the section [mysqldump] (just like there is [client], you could create it if you haven't) and try the command without putting max_allowed_packet into the command, it should work too. Sincerely, -- Guillaume Fenollar XWiki SysAdmin Tel : +33 (0)1.83.62.65.97 2012/1/13 goldring, richard <[email protected]>

Hi All,

Running ... mysqldump nms_wiki > backup.sql

Returns ... mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `xwikiattrecyclebin` at row: 2

I did have some rather large import attachments - which I deleted but they seem to have gone into the recycle bin - so I used the code snippet http://extensions.xwiki.org/xwiki/bin/view/Extension/Empty+Trash+Bin

To supposedly empty the bin, but get the same error above when I try and dump the database seeming to indicate the recycle bin isn't empty.

Tried increasing the max_allowed_packet when I run mysql, but doesn't seem to have any affect - is something overriding it? We're running on Solaris.

Any ideas/help would be appreciated so I can backup the wiki successfully on mysql!!!!

Thanks.

Regards,

Richard _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users