zzl001 发表于 2018-10-7 07:42:41

mysql导出数据报错

  # /usr/bin/mysqldump -uroot -proottp-monitor >>/opt/backup/$mysqlname.sql
  mysqldump: unknown option '--no-beep'
  改成如下:
  root@HWJMYSQL2 log]# /usr/bin/mysqldump --no-defaults -uroot -proottp-monitor >>/opt/backup/mysqlname.sql
  # /usr/bin/mysqldump --no-defaults -uroot -proottp-monitor >>/opt/backup/mysqlname.sql
  Warning: Using a password on the command line interface can be insecure.
  mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
  改成如下:
  # netstat -ln | grep mysql
  unix2      [ ACC ]   STREAM   LISTENING   96606352 /opt/mysql/mysql.sock
  # /usr/bin/mysqldump --no-defaults --sock=/opt/mysql/mysql.sock -uroot -proottp-monitor >>/opt/backup/mysqlname.sql
  转自:
  http://blog.csdn.net/xiaogugood/article/details/16335193
  http://blog.csdn.net/seteor/article/details/18356079

页: [1]
查看完整版本: mysql导出数据报错