Issue Unable to make database dump

[Rar9]

How to resolve this The Database is about 650MB large. Table Session is 315MB.

Unable to make database dump. Error:
Failed to exec mysqldump: mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table `sessions` at row: 0

How to fix this as i can't even dumpt the DB via Gui


/usr/local/psa/admin/conf/php.ini

short_open_tag = On
y2k_compliance = Off
output_buffering = Off
max_execution_time = 600
max_input_time = 600
memory_limit = 2048M
max_file_uploads = 99999
max_input_vars = 2000


/etc/mysql/my.cnf

collation_server=utf8mb4_unicode_ci
character_set_server=utf8mb4
skip-character-set-client-handshake

innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true
innodb_buffer_pool_size=2048M
query_cache_size=64M
max_allowed_packet=2048M
open_files_limit = 65535

 

[MarkM]

You can add something such as --max_allowed_packet=512M to your mysqldump command.

 

[Rar9]

this might be the manual solution, but I require PLESK BACKUP Manager to work

 

[MarkM]

Ok, you will want to increase the max_allowed_packet option under the mysqldump section in the my.cnf file.

/etc/mysql/my.cnf

 

[Rar9]

This is why i already posted theses 2 files.


$ cat /etc/mysql/my.cnf | grep 'max_allowed_packet'

max_allowed_packet=2048M

MariaDB [psa]> Select @@global.max_allowed_packet;

+-----------------------------+

| @@global.max_allowed_packet |

+-----------------------------+

| 1073741824 |

 

[MarkM]

Is it specifically under the [mysqldump] section?

 

[Rar9]

I added 2048mb to [mysqldump]
Rebooted Mysql
no change

But according to MariaDB Documentation max is 1 GB mysqldump

So I'm out of ideas

 

[Rar9]

Yes but i only get the 1gb.