There is the warning when I run database backup bash script

Question

My database is 8GB

When I run the database backup bash script, there is the warning/failure. They have appeared since 1 month ago

Here are my warning/failure

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `xxx` at row: 427348 

mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'xxx'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006) 
.....

mysqldump: Couldn't execute 'UNLOCK TABLES': MySQL server has gone away (2006)
mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)" when trying to connect

What in the **server** log corresponds to this client message? What it is doing that time? — Nikita Kipriyanov, May 26 '22 at 10:53

score 1 · Answer 1 · answered May 30 '22 at 04:32

The Error 2013: Lost connection to MySQL server and MySQL server has gone away (2006) errors always mean that the connection between the program and the database was broken unexpectedly. Usually this happens due to the connection being killed by something, server running out of memory or due to a bug that ends up crashing the server process.

To find out what actually caused this, inspect the server error logs which by default is /var/lib/mysql/hostname.err.

there isn't any file .err in my server. I searched it – Bach Do Jun 01 '22 at 10:23 — Bach Do, Jun 01 '22 at 10:23

score 0 · Answer 2 · answered May 26 '22 at 09:53

0

If the server is not restarting for some reason, adding --quick --single-transaction to mysqldump may help.

answered May 26 '22 at 09:53

Halfgaar

8,084
6
45
86

Can you guide me more detail? I am newbie :( – Bach Do Jun 01 '22 at 10:24

There is the warning when I run database backup bash script

2 Answers2