gistfile1.txt

[root@holland ~]# mysql -uroot -p`cat /root/pwfile`
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.1.47-ius Distributed by The IUS Community Project

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password = password('crazysh!t$%&#&%^##%(');
Query OK, 0 rows affected (0.00 sec)

mysql> Bye

[root@holland ~]# cat /root/pwfile 
crazysh!t$%&#&%^##%(

[root@holland ~]# holland bk
Holland 1.0.0 started with pid 3330
--- Starting backup run ---
Acquired lock /etc/holland/backupsets/default.conf : '/etc/holland/backupsets/default.conf'
Loaded password file /root/pwfile
Purged default/20100628_080631
1 backups purged
Estimating size of mysqldump backup
Estimated Backup Size: 204.00MB
Starting backup[default/20100630_021230] via plugin mysqldump
Using mysqldump executable: /usr/bin/mysqldump
mysqldump version 5.1.47
Using /bin/gzip compression level 1
Saving mysqldump output to MANIFEST.txt (uncompressed)
Saving mysqldump output to employees.sql.gz (gzip compressed level 1)
Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20100630_021230/my.cnf --single-transaction employees
/usr/bin/mysqldump[3334]: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
Backup completed in 0.49 seconds
Backup failed.  Cleaning up.
Purged failed backup: default/20100630_021230
Backup failed: mysqldump exited with non-zero status 2
Released lock /etc/holland/backupsets/default.conf
--- Ending backup run ---

[root@holland ~]# mysql -uroot -p`cat /root/pwfile`
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 26
Server version: 5.1.47-ius Distributed by The IUS Community Project

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password = password('password');
Query OK, 0 rows affected (0.00 sec)

mysql> Bye

[root@holland ~]# echo password > /root/pwfile 
[root@holland ~]# mysql -uroot -p`cat /root/pwfile`
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 27
Server version: 5.1.47-ius Distributed by The IUS Community Project

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> Bye
[root@holland ~]# holland bk
Holland 1.0.0 started with pid 3339
--- Starting backup run ---
Acquired lock /etc/holland/backupsets/default.conf : '/etc/holland/backupsets/default.conf'
Loaded password file /root/pwfile
No backups purged
Estimating size of mysqldump backup
Estimated Backup Size: 204.00MB
Starting backup[default/20100630_021302] via plugin mysqldump
Using mysqldump executable: /usr/bin/mysqldump
mysqldump version 5.1.47
Using /bin/gzip compression level 1
Saving mysqldump output to MANIFEST.txt (uncompressed)
Saving mysqldump output to employees.sql.gz (gzip compressed level 1)
Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20100630_021302/my.cnf --single-transaction employees
Saving mysqldump output to menagerie.sql.gz (gzip compressed level 1)
Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20100630_021302/my.cnf --lock-tables menagerie
Saving mysqldump output to mysql.sql.gz (gzip compressed level 1)
Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20100630_021302/my.cnf --lock-tables mysql
Saving mysqldump output to sakila.sql.gz (gzip compressed level 1)
Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20100630_021302/my.cnf --lock-tables sakila
Saving mysqldump output to test.sql.gz (gzip compressed level 1)
Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20100630_021302/my.cnf --lock-tables test
Saving mysqldump output to test3.sql.gz (gzip compressed level 1)
Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20100630_021302/my.cnf --single-transaction test3
Saving mysqldump output to world.sql.gz (gzip compressed level 1)
Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20100630_021302/my.cnf --lock-tables world
Final on-disk backup size 46.84MB 22.96% of estimated size 204.00MB
Backup completed in 13.85 seconds
Released lock /etc/holland/backupsets/default.conf
--- Ending backup run ---