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 <richard.goldring(a)uk.thalesgroup.com
> 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
> users(a)xwiki.org
>
http://lists.xwiki.org/mailman/listinfo/users