Laurent CREPET
2014-May-09 16:19 UTC
[Puppet Users] puppetlabs-mysql - question about automated backup script mysqlbackup.sh
Hi,
I'm using module puppetlabs-mysql and its automated backup script creation.
When using:
class { '::mysql::server::backup':
backupuser => '<mybackupuser>',
backuppassword => '<mypwd>,
file_per_database => true,
[...]
}
...the script looks like:
===mysql -s -r -N -e 'SHOW DATABASES' | while read dbname
do
mysqldump -u${USER} -p${PASS} --opt --flush-logs --single-transaction \
${EVENTS} \
${dbname} | bzcat -zc > ${DIR}/${PREFIX}${dbname}_`date
+%Y%m%d-%H%M%S`.sql.bz2
done
if [ $? -eq 0 ] ; then
cleanup
fi
===
So,
- mysqldump will use the credentials given to ::mysql::server::backup
- mysql won't use these credentials, so will fallback to settings from
/root/.my.cnf
Why not using the same credentials for both ?
-- Laurent.
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to puppet-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/f5e063ce-289a-4bdb-978a-ee3ff17c4ad1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.