There is the warning when I run database backup bash script

Bach Do

9/26/23, 9:15 AM

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

0 + 0

mysql5

mariadb

Nikita Kipriyanov

9/26/23, 10:53 AM

What in the **server** log corresponds to this client message? What it is doing that time?

Score:1

Server

markusjm

9/30/23, 4:32 AM

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.

0 + 0

Bach Do

10/1/23, 10:23 AM

there isn't any file .err in my server. I searched it

Score:0

Server

Halfgaar

9/26/23, 9:53 AM

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

0 + 0

Bach Do

10/1/23, 10:24 AM

Can you guide me more detail? I am newbie :(

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: There is the warning when I run database backup bash script

TH: มีคำเตือนเมื่อฉันรันสคริปต์ทุบตีสำรองฐานข้อมูล

RO: Există un avertisment când rulez scriptul bash de backup pentru baze de date

RU: Есть предупреждение, когда я запускаю bash-скрипт резервного копирования базы данных

VI: Có cảnh báo khi tôi chạy tập lệnh bash sao lưu cơ sở dữ liệu

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.