Re: [xwiki-users] Backing up xwiki using mysql

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-bounces(a)xwiki.org [mailto:users-bounces@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.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 _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users