After migrating to 6.0.29, we are getting the following error trying to do an export (mysqldump):
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `package_repository` at row: 3
we have increased the max_allowed_packet in my.cnf to 3000M - still getting the error.
Any ideas/suggestions?
M
Problem getting export 6.0.29 - package_repository - [SOLVED]
Moderator: crythias
-
- Znuny expert
- Posts: 213
- Joined: 02 Dec 2010, 16:53
- Znuny Version: 6.0.29
- Real Name: Marc
- Company: National Jewish Health
- Location: Denver, CO
Problem getting export 6.0.29 - package_repository - [SOLVED]
Last edited by kruegerM on 26 Oct 2020, 20:46, edited 1 time in total.
Re: Problem getting export 6.0.29 - package_repository
mysqldump wants its own setting in the my.cnf (or as command line option)
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny superhero
- Posts: 889
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: Problem getting export 6.0.29 - package_repository
Just add '--max_allowed_packet=512M' to your mysqldump command.
— Emin
— Emin
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
-
- Znuny expert
- Posts: 213
- Joined: 02 Dec 2010, 16:53
- Znuny Version: 6.0.29
- Real Name: Marc
- Company: National Jewish Health
- Location: Denver, CO
Re: Problem getting export 6.0.29 - package_repository - [SOLVED]
Thank you - both solutions work - we'll stick with adding the [mysqldump] section to my.cnf