执行innobackupex --user=root --password=xxxxxx /backup/ 报错如下图
Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','root' ,...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at - line 1314.
221117 18:07:00 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/var/ lib/mysql/mysql.sock' (2).
由于服务器同时开启多个实例,导致只输入root和密码是无法执行innobackupex全备份。
解决办法,将--user、--password、--port、--socket都输入齐了,如下命令
[root@MyCentOS backup]# innobackupex --user=root --password=xxxxxx --port=3306 --socket=/tmp/mysql.sock --no-timestamp /backup/full/