Thanks Guillaume - it worked a treat - I'll setting up the my.cnf another
time, but at least I can backup now!

Does anyone know more about the recycle bin - don't seem able to access from
the wiki, and (I guess any deleted wiki pages or attachments go into it?)
the code snippet didn't seem to empty it from the database - any ideas how
to empty it?

-----Original Message-----
From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of
Guillaume Fenollar
Sent: 13 January 2012 08:55
To: XWiki Users
Subject: Re: [xwiki-users] Backing up xwiki using mysql

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.goldr...@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@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to