Backup Issue

[Mahesh]

Hello,

I am getting below error while trying to run backup.pl --

Error message is --- "Dump MySQL rdbms ... mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `ar ticle_plain` at row: 652"

My OS is CentOS 64bit and I am using mysql database. The OTRS version is -- 4.01.11

Thanks
Mahesh

[RStraub]

Do you remember when you installed how it said that you need a max_allowed_package_size for the mysql config?

The same is needed for mysql-dump (which is the same command, but under a different tag).

Check your /etc/mysql/my.cnf and make sure that under the [mysql] AND [mysqldump] theres a line like this:
max_allowed_packet = 20M

[Mahesh]

This is already defined. My location is /etc/my.cnf.

The value currently is --- max_allowed_packet=102400M

Any further ideas....

[root]

And you're sure the you specified this value under the [mysqld] and [mysqldump] section?

[Mahesh]

Here is the my.cnf --

Let me know if i have to add some lines to it.
--------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=root
max_allowed_packet=102400M
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

net_buffer_length=100M
#query_cache_size=100M
_____________________________________

[RStraub]

yeah, nothing regarding the [mysqldump] part

[Mahesh]

I added it and its working fine now. Thanks ...

[Giulio Soleni]

Error message is --- "Dump MySQL rdbms ... mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `ar ticle_plain` at row: 652"

By the way ... not a good idea in my humble opinion, to store the articles within the database, expecially if you have many tickets to manage.
It would be better to store them in the filesystem.
To do so, edit config settings in Ticket -> Core::Ticket
Ticket::StorageModule = ArticleStorageFS

The only drawback is that searching for attachment names is not supported when "FS" is used.