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

2012-01-13 Thread goldring, richard
'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 R

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

2012-01-13 Thread Guillaume Fenollar
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

[xwiki-users] Backing up xwiki using mysql

2012-01-13 Thread goldring, richard
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