☰
✕
✕
0

Lost connection to MySQL server during query when dumping table

I am facing the following issue what is the solution to fix the issue
-- Connecting to localhost...
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
Dump started for ============whatisca_db=========================
-- Connecting to localhost...
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

MySQL MySQLDumper
Add a comment
jacob
asked Aug 31 2019

Answer

0

Enter into mysql and Run the following command to fix the issue

  • SET GLOBAL net_write_timeout=3600;
  • SET GLOBAL net_read_timeout=3600;
Add a comment
linuxhelp
asked Aug 31 2019
Post your Answer