XtraBackup备份时出现的socket报错解决
今天为公司新建的uat数据库使用XtraBackup备份时,出现了报错,将解决方法整理、做一下备忘:
服务器系统:
[root@uat-mysql-master tmp]# cat /etc/RedHat-release CentOS Linux release 7.3.1611 (Core) mysql版本号:mysql> select version();+----------------+| version() |+----------------+| 5.5.47-cll-lve |+----------------+1 row in set (0.00 sec)报错如下:[root@uat-mysql-master tmp]# innobackupex --defaults-file=/etc/my.cnf --user=backup --password=****** --stream=tar /home/backup/ | gzip >/home/backup/`date +%F_%H-%M-%S`.tar.gz171120 17:10:42 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 171120 17:10:42 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'backup' (using password: YES).Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','backup',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at - line 1314.171120 17:10:42 Connecting to MySQL server host: localhost, user: backup, password: set, port: not set, socket: not setFailed to connect to MySQL server: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).解决办法:
在命令行中添加
--host=127.0.0.1
参数;
备注:网上有的说,通过
# find / -name "mysql.sock"
查到socket参数,然后在配置文件中修改,但测试后,不一定能解决问题。
更多XtraBackup相关教程见以下内容:
相关推荐
dflyzx 2020-09-17
higheels 2020-07-20
Ericbig 2020-07-19
yinyang00 2020-05-15
lijiuchangxin 2020-05-14
yogoma 2020-05-09
jacktangj 2020-04-19
Yyqingmofeige 2020-03-26
idning 2020-02-14
宿舍 2020-01-31
luenxin 2020-01-22
水痕 2020-01-18
chouliqingke 2020-01-08
secondid 2019-12-18
XCodeRush 2019-12-17
ryuhfxz 2019-11-20
qonsnow 2014-03-07
coulder 2019-11-17