mysql导出数据报错
# /usr/bin/mysqldump -uroot -proottp-monitor >>/opt/backup/$mysqlname.sqlmysqldump: 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]