mysqldump导出报错

mysqldump --single-transaction --set-gtid-purged=OFF  -q -e  --insert-ignore --triggers=false -w "end_time>='2022-11-01 00:00:00'"  -uyouname -pyourpwd dbname tablname > /home/sdnmuser/tablename.sql &
 

如果遇到

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect

查看mysql的sock文件目录

[sdnmuser@oss-nmbaz-db-250 socket_8802]$ netstat -ln|grep mysql
unix  2      [ ACC ]     STREAM     LISTENING     12991569 /data1/mysql_8801.sock

创建软链接： 

ln -s  /data1/mysql_8801.sock  /tmp/mysql.sock

重新执行即可。