Can´t dump mysql to create backup of otrs database - otrs - OTRS mailing lists

newer
default agent preferences

Can´t dump mysql to create backup of otrs database

older
X509 Client Certificate...

Markus Moj

8 Apr 2010 8 Apr '10

11:31 a.m.

Hi there, I need to make a backup of the OTRS Database but I always get this error: Got packet bigger than 'max_allowed_packet' bytes when dumping table `article_attachment` at row: 39045 The packed size for mysql is set to 256 MB which was before 128 MB. Can anyone help me to workaraound this problem to geht things working again. Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: mmoj@timocom.com Internet: www.timocom.com Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489

Attachments:

attachment.html (text/html — 1.1 KB)

Reply

Sign in to reply online Use email software

Show replies by date

Marco Vannini

8 Apr 8 Apr

12:15 p.m.

try this http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org or http://goo.gl/lOa5 (faq.otrs.org) hth MV On Thu, Apr 8, 2010 at 1:31 PM, Markus Moj wrote:

max_allowed_packet

Reply

Sign in to reply online Use email software

Markus Moj

12:26 p.m.

Hi, Well that won´t help me. I know how to abjust the packeg size in the mysql config file. max_allowed_packet=256M query_cache_size=256M This is the cat from the my.cnf. The max. size of attachement in the Database is about 36MB so there shoulb be enough space to handle such a dump. Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: mmoj@timocom.com Internet: www.timocom.com Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489 From: Marco Vannini To: "User questions and discussions about OTRS." Date: 08.04.2010 14:16 Subject: Re: [otrs] Can´t dump mysql to create backup of otrs database Sent by: otrs-bounces@otrs.org try this http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org or http://goo.gl/lOa5 (faq.otrs.org) hth MV On Thu, Apr 8, 2010 at 1:31 PM, Markus Moj wrote: max_allowed_packet --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Reply

Sign in to reply online Use email software

Anton Gubar'kov

1:19 p.m.

Markus, check the section of my.cnf you have max_allowed_packet in. It should be in [mysqld] _/*and */_[mysqldump] Regard, Anton. 08.04.2010 16:26, Markus Moj ?????:

Hi,

Well that won´t help me. I know how to abjust the packeg size in the mysql config file.

max_allowed_packet=256M query_cache_size=256M

This is the cat from the my.cnf.

The max. size of attachement in the Database is about 36MB so there shoulb be enough space to handle such a dump.

Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services

TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: _mmoj@timocom.com_ mailto:mmoj@TimoCom.com Internet: _www.timocom.com_

Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489

Inactive hide details for Marco Vannini ---08.04.2010 14:16:36---try this http://www.mail-archive.com/search?q=max_allowed_packMarco Vannini ---08.04.2010 14:16:36---try this http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org

From: Marco Vannini

To: "User questions and discussions about OTRS."

Date: 08.04.2010 14:16

Subject: Re: [otrs] Can´t dump mysql to create backup of otrs database

Sent by: otrs-bounces@otrs.org

------------------------------------------------------------------------

try this

_http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org_ http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org

or

_http://goo.gl/lOa5_ (_faq.otrs.org_ http://faq.otrs.org/)

hth

MV

On Thu, Apr 8, 2010 at 1:31 PM, Markus Moj <_MMoj@timocom.com_ mailto:MMoj@timocom.com> wrote:

max_allowed_packet

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Reply

Sign in to reply online Use email software

Markus Moj

2:24 p.m.

Well that didn´t help either. Anyone another attemp to give me a hint? Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: mmoj@timocom.com Internet: www.timocom.com Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489 From: Anton Gubar'kov To: otrs@otrs.org Date: 08.04.2010 15:20 Subject: Re: [otrs] Can´t dump mysql to create backup of otrs database Sent by: otrs-bounces@otrs.org Markus, check the section of my.cnf you have max_allowed_packet in. It should be in [mysqld] and [mysqldump] Regard, Anton. 08.04.2010 16:26, Markus Moj пишет: Hi, Well that won´t help me. I know how to abjust the packeg size in the mysql config file. max_allowed_packet=256M query_cache_size=256M This is the cat from the my.cnf. The max. size of attachement in the Database is about 36MB so there shoulb be enough space to handle such a dump. Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: mmoj@timocom.com Internet: www.timocom.com Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489 Inactive hide details for Marco Vannini ---08.04.2010 14:16:36---try this http://www.mail-archive.com/search?q=max_allowed_packMarco Vannini ---08.04.2010 14:16:36---try this http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org From: Marco Vannini To: "User questions and discussions about OTRS." Date: 08.04.2010 14:16 Subject: Re: [otrs] Can´t dump mysql to create backup of otrs database Sent by: otrs-bounces@otrs.org try this http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org or http://goo.gl/lOa5 (faq.otrs.org) hth MV On Thu, Apr 8, 2010 at 1:31 PM, Markus Moj wrote: max_allowed_packet --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Reply

Sign in to reply online Use email software

Guillaume Rehm

9 Apr 9 Apr

9:33 a.m.

Sorry for that, but do you have restart your mysql server ?? Le 08/04/2010 16:24, Markus Moj a écrit :

Well that didn´t help either.

Anyone another attemp to give me a hint?

Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services

TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: _mmoj@timocom.com_ mailto:mmoj@TimoCom.com Internet: _www.timocom.com_

Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489

Inactive hide details for Anton Gubar'kov ---08.04.2010 15:20:19---Markus, check the section of my.cnf you have max_allowed_pacAnton Gubar'kov ---08.04.2010 15:20:19---Markus, check the section of my.cnf you have max_allowed_packet in. It should be in [mysqld] _/*and

From: Anton Gubar'kov

To: otrs@otrs.org

Date: 08.04.2010 15:20

Subject: Re: [otrs] Can´t dump mysql to create backup of otrs database

Sent by: otrs-bounces@otrs.org

------------------------------------------------------------------------

Markus, check the section of my.cnf you have max_allowed_packet in. It should be in [mysqld] */and /* <mysqldump>

Regard, Anton. 08.04.2010 16:26, Markus Moj пишет:

Hi,

Well that won´t help me. I know how to abjust the packeg size in the mysql config file.

max_allowed_packet=256M query_cache_size=256M

This is the cat from the my.cnf.

The max. size of attachement in the Database is about 36MB so there shoulb be enough space to handle such a dump.

Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services

TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: _mmoj@timocom.com_ mailto:mmoj@TimoCom.com Internet: _www.timocom.com_

Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489

Inactive hide details for Marco Vannini ---08.04.2010 14:16:36---try this http://www.mail-archive.com/search?q=max_allowed_packMarco Vannini ---08.04.2010 14:16:36---try this _http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org_ http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org

From: Marco Vannini __ mailto:marco.vannini@gmail.com

To: "User questions and discussions about OTRS." __ mailto:otrs@otrs.org

Date: 08.04.2010 14:16

Subject: Re: [otrs] Can´t dump mysql to create backup of otrs database

Sent by: _ __otrs-bounces@otrs.org_ mailto:otrs-bounces@otrs.org

------------------------------------------------------------------------

try this _ __http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org_ http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org

or _ __http://goo.gl/lOa5_ (_faq.otrs.org_ http://faq.otrs.org/)

hth

MV

On Thu, Apr 8, 2010 at 1:31 PM, Markus Moj <_MMoj@timocom.com_ mailto:MMoj@timocom.com> wrote: max_allowed_packet --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: _http://otrs.org/_ Archive: _http://lists.otrs.org/pipermail/otrs_ To unsubscribe: _http://lists.otrs.org/cgi-bin/listinfo/otrs_

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!_ __http://www.otrs.com/en/support/enterprise-subscription/_

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: _http://otrs.org/_ Archive: _http://lists.otrs.org/pipermail/otrs_ To unsubscribe: _http://lists.otrs.org/cgi-bin/listinfo/otrs_

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! _http://www.otrs.com/en/support/enterprise-subscription/_

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

-- Guillaume REHM Centre de Ressources Informatiques Responsable Sécurité du Système d'Information (RSSI) Bibliothèque Nationale et Universitaire de Strasbourg 5 rue du Maréchal Joffre BP 51029 67070 Strasbourg tél: 03 88 25 28 23 fax: 03 88 25 28 03 mail: guillaume.rehm@bnu.fr web: http://www.bnu.fr

Reply

Sign in to reply online Use email software

Markus Moj

8 Apr 8 Apr

3:11 p.m.

Ok, thanks, after a reboot of the server everything works fine. Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: mmoj@timocom.com Internet: www.timocom.com Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489 From: Anton Gubar'kov To: otrs@otrs.org Date: 08.04.2010 15:20 Subject: Re: [otrs] Can´t dump mysql to create backup of otrs database Sent by: otrs-bounces@otrs.org Markus, check the section of my.cnf you have max_allowed_packet in. It should be in [mysqld] and [mysqldump] Regard, Anton. 08.04.2010 16:26, Markus Moj пишет: Hi, Well that won´t help me. I know how to abjust the packeg size in the mysql config file. max_allowed_packet=256M query_cache_size=256M This is the cat from the my.cnf. The max. size of attachement in the Database is about 36MB so there shoulb be enough space to handle such a dump. Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: mmoj@timocom.com Internet: www.timocom.com Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489 Inactive hide details for Marco Vannini ---08.04.2010 14:16:36---try this http://www.mail-archive.com/search?q=max_allowed_packMarco Vannini ---08.04.2010 14:16:36---try this http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org From: Marco Vannini To: "User questions and discussions about OTRS." Date: 08.04.2010 14:16 Subject: Re: [otrs] Can´t dump mysql to create backup of otrs database Sent by: otrs-bounces@otrs.org try this http://www.mail-archive.com/search?q=max_allowed_packet&l=otrs@otrs.org or http://goo.gl/lOa5 (faq.otrs.org) hth MV On Thu, Apr 8, 2010 at 1:31 PM, Markus Moj wrote: max_allowed_packet --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Reply

Sign in to reply online Use email software

5580

Age (days ago)

5581

Last active (days ago)

Download

6 comments

4 participants

tags

participants (4)

Anton Gubar'kov
Guillaume Rehm
Marco Vannini
Markus Moj