mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `wp_xxx` at row: 1666
Hi everybody,
i read this issue on this forum but i can not fix this error.
when i backup my database with mysqldump, this error appear :
"mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `wp_xxxx` at row: 1666."
I've tried config below :
vi /etc/my.cnf
Add the following lines under the [mysqld] section:
innodb_buffer_pool_size=100M
max_allowed_packet=1024M
net_read_timeout=3600
net_write_timeout=3600
This is my info server :
Database server
Server: Localhost via UNIX socket
Server type: MariaDB
Server version: 10.1.43-MariaDB - MariaDB Server
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)
Web server
Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.2.24
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id:
3591daad22de08524295e1bd073aceeff11e6579 $
PHP extension: mysqli Documentation
PHP version: 7.2.24
[root@mail ~]# mysql -V
mysql Ver 15.1 Distrib 10.1.43-MariaDB, for Linux (x86_64) using readline 5.1
[root@mail ~]# service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB 10.1.43 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Tue 2019-11-19 15:06:58 +07; 1h 53min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 14976 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 14923 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 14921 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 14948 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─14948 /usr/sbin/mysqld
Nov 19 15:06:57 mail.bephyn.com mysqld[14948]: 2019-11-19 15:06:57 139708696041728 [Note] InnoDB: Highest supported file format is Barracuda.
Nov 19 15:06:58 mail.bephyn.com mysqld[14948]: 2019-11-19 15:06:58 139708696041728 [Note] InnoDB: 128 rollback segment(s) are active.
Nov 19 15:06:58 mail.bephyn.com mysqld[14948]: 2019-11-19 15:06:58 139708696041728 [Note] InnoDB: Waiting for purge to start
Nov 19 15:06:58 mail.bephyn.com mysqld[14948]: 2019-11-19 15:06:58 139708696041728 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.45-86.1 started; lo...0599296785
Nov 19 15:06:58 mail.bephyn.com mysqld[14948]: 2019-11-19 15:06:58 139707472144128 [Note] InnoDB: Dumping buffer pool(s) not yet started
Nov 19 15:06:58 mail.bephyn.com mysqld[14948]: 2019-11-19 15:06:58 139708696041728 [Note] Plugin 'FEEDBACK' is disabled.
Nov 19 15:06:58 mail.bephyn.com mysqld[14948]: 2019-11-19 15:06:58 139708696041728 [Note] Server socket created on IP: '::'.
Nov 19 15:06:58 mail.bephyn.com mysqld[14948]: 2019-11-19 15:06:58 139708696041728 [Note] /usr/sbin/mysqld: ready for connections.
Nov 19 15:06:58 mail.bephyn.com mysqld[14948]: Version: '10.1.43-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
Nov 19 15:06:58 mail.bephyn.com systemd[1]: Started MariaDB 10.1.43 database server.
[root@mail hyndb_bk]# mysqldump -uroot -p db_name > dump.sql
Enter password:
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `wp_posts` at row: 1666
So i can not backup my database.Please help me this.Thanks a lot.