MySQL Forums
Forum List  »  Backup

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `wp_xxx` at row: 1666
Posted by: Tran Hung
Date: November 19, 2019 04:11AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `wp_xxx` at row: 1666
3898
November 19, 2019 04:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.