各位,情况是这样的
Linux oracle12c 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
执行
/usr/bin/innobackupex--defaults-file=/data/mysqldata/3306/my.cnf --databases=test --user=xtrabak --password='onlybackup'/data/mysqldata/innobackupex_test;
可以进行正常的备份
但是写入一个脚本---脚本引用的三思的脚本DATA_PATH=/data/mysqldata/innobackupex_testDATA_FILE=${DATA_PATH}/innobackupex_testbak_`date +%F`.tar.gzLOG_FILE=${DATA_PATH}/innobakcupex_testbak_`date +%F`.logORI_CONF_FILE=/data/mysqldata/3306/my.cnfNEW_CONF_FILE=${DATA_PATH}/my_3306_`date +%F`.cnfMYSQL_PATH=/usr/binMYSQL_CMD="${MYSQL_PATH}/innobackupex --defaults-file=${ORI_CONF_FILE} --databases=test --user=xtrabak --password='onlybackup' --stream=tar /tmp"echo >$LOG_FILEecho -e "===jobs started as `date +%F' '%T' '%w` ===\n" >> $LOG_FILEecho -e "===first cp my.cnf file to backup directory ===" >> $LOG_FILE/bin/cp ${ORI_CONF_FILE} ${NEW_CONF_FILE}echo >> $LOG_FILEecho -e "*** executed cammand:${MYSQL_CMD} | gzip > ${DATA_FILE}" >> $LOG_FILE${MYSQL_CMD} 2>>${LOG_FILE} |gzip - >${DATA_FILE}echo -e "*** executed finished at `date +%F' '%T' '%w`====" >> $LOG_FILEecho -e "*** backup file size: `du -sh ${DATA_FILE}`===\n" >> $LOG_FILEecho -e "----find expired backup and delete those files ----">> $LOG_FILEfor tfile in $(/usr/bin/find $DATA_PATH/ -mtime +6)doif [ -d $tfile ] ; thenrmdir $tfile elif [ -f $tfile ]; thenrm -f $tfilefi echo -e "----delete filr:$tfile ----">> $LOG_FILEdoneecho -e "\n=== jobs dened at `date +%F' '%T' '%w`===\n">> $LOG_FILE复制代码就报错
150701 19:25:23innobackupex: Executing a version check against the server...
150701 19:25:23innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/data/mysqldata/3306/my.cnf;mysql_read_default_group=xtraba
ckup' as 'xtrabak'(using password: YES).
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3011
main::mysql_connect('abort_on_error', 1) called at /usr/bin/innobackupex line 1551
innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_file=/data/mysqldata/3306/my.cnf;mysql_read_default_group=xtrabackup','xt
rabak',...) failed: Access denied for user 'xtrabak'@'localhost' (using password: YES) at /usr/bin/innobackupex line 2995
150701 19:25:23innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/data/mysqldata/3306/my.cnf;mysql_read_default_group=xtraba
ckup' as 'xtrabak'(using password: YES).
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3011
main::mysql_connect('abort_on_error', 1) called at /usr/bin/innobackupex line 1570
innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_file=/data/mysqldata/3306/my.cnf;mysql_read_default_group=xtrabackup','xt
rabak',...) failed: Access denied for user 'xtrabak'@'localhost' (using password: YES) at /usr/bin/innobackupex line 2995
|