在linux环境下将mysql中某个表导出为sql脚本,执行命令:
mysqldump -uroot -p密码 liqun i_billmain --where="czsj>'2018-07-24 00:00:00'" > /home/mysql/main-20180724.sql
时报错:
mysqldump: Got error: 2002: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2)
when trying to connect
解决:修改命令
mysqldump -h127.0.0.1 -uroot -p密码 liqun i_billmain
--where="czsj>'2018-07-24 00:00:00'" > /home/mysql/main-20180724.sql
OK