MySqldump Error 2013: Lost Connection

Hello All,
I am use Prestashop.
am create a script for auto backup of whole database of my site
but from last few given this error and backup terminate at this table.

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table ps_layered_filter_block at row: 107002

am change some value in my.cnf file but not work for me

#my.cnf file

#Bitnami MySQL Configuration
#Copyright 2019 Bitnami.com All Rights Reserved

#Note: This file will be modified on server size changes

[mysqld]
net_read_timeout = 1200
net_write_timeout = 1900
wait_timeout = 320
long_query_time = 1
query_cache_limit=20M
query_cache_type=1
query_cache_size=512M
innodb_buffer_pool_size=4096M
innodb_force_recovery = 1
innodb_log_file_size=128M
tmp_table_size=64M
max_connections = 2500
max_user_connections = 2500
innodb_flush_method=O_DIRECT
key_buffer_size=64M

[mysqladmin]
user=root

[mysqld]
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION
basedir=/opt/bitnami/mysql
datadir="/opt/bitnami/mysql/data"
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
tmpdir=/opt/bitnami/mysql/tmp
max_allowed_packet=512M
bind-address=127.0.0.1
skip-name-resolve=1
default-authentication-plugin=mysql_native_password

character-set-server=UTF8
collation-server=utf8_general_ci
[client]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock

default-character-set=UTF8
[manager]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
pid-file=/opt/bitnami/mysql/tmp/manager.pid
default-mysqld-path=/opt/bitnami/mysql/bin/mysqld.bin

!include /opt/bitnami/mysql/bitnami/my.cnf

but Problem Stil Same.

mysqldump -u root -p bitnami_prestashop > /home/{username}/dbbackup/db_13_07_2020.sql
also try
mysqldump -u root -p --extended-insert bitnami_prestashop > /home/{username}/dbbackup/db_13_07_2020.sql

our database size
±-------------------±-------------+
| bitnami_prestashop | Size in (MB) |
±-------------------±-------------+
| bitnami_prestashop | 8515.77 |
|
| information_schema | 0.16 |
| mysql | 3.82 |
| performance_schema | 0.00 |
| sys | 0.02 |
±-------------------±-------------+

on disk size

11G /opt/bitnami/mysql/data/bitnami_prestashop
21M /opt/bitnami/mysql/data/mysql
11G /opt/bitnami/mysql/data

Please Provide solution as soon as posibal thanks

Hi @sayyedyusuf1990,

Thanks for using Bitnami. What version of MySQL do you have?

We have a Support Tool that will gather relevant information for us to analyze your configuration and logs. Could you please execute it on the machine where the stack is running by following the steps described in the guide below?

Please note that you need to paste the code ID that is shown at the end.

Regards,
Ibone.

Mysql version
/opt/bitnami/mysql/bin/mysql.bin Ver 14.14 Distrib 5.7.24, for linux-glibc2.12 (x86_64) using EditLine wrapper

Hi @sayyedyusuf1990,

Could you check this thread https://forums.mysql.com/read.php?10,597712,597766#msg-597766?

I hope that helps you,
Ibone.

still, the same error will be getting.
:cry::cry::cry::cry::cry:

Hi @sayyedyusuf1990,

Thank you for using our solution. Please note that Bitnami packages and configures already existing applications. However, we can only offer support and help on basic and most frequent application configurations. Always based on the default configuration or on our guides.
If the question is related to the application itself or any third party tool, probably someone with more experience and knowledge about that specific tool can help you better than we can. We suggest you to post your question on the official support forums of the application so others can help you.

https://forums.mysql.com/

Do not hesitate to write us back if you have any other questions regarding the Bitnami solutions or their configuration.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.