mysqldump: Got error: 2002: Can't connect to local MySQL server through socke...

jiawang

使用mysqldump备份所有数据库报错：
[root@sztech ~]# mysqldump -uroot -p --socket=/data/mysql/mysql.sock --all-databases > all_databases_backup.sqlEnter password:
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/data/mysql/mysql.sock' (2) when trying to connect


因为mysql的socket文件读取异常（文件可能已删除），导致socket无法连接所致


确认当前MySQL的socket
[root@sztech ~]# netstat -ln | grep mysql
unix  2      [ ACC ]     STREAM     LISTENING     243800   /var/lib/mysql/mysql.sock

用正确的socket文件连接mysql，再次执行mysqdump命令：
[root@sztech ~]# mysqldump -uroot -p --socket=/var/lib/mysql/mysql.sock --all-databases > all_databases_backup.sql
Enter password:
[root@sztech ~]# ll
total 864
-rw-r--r--. 1 root root 873551 Aug  5 18:15 all_databases_backup.sql