AUTOMySQLBackup: Looking for .my.cnf in your $HOME instead of in /root
1root@rh:~# /usr/local/bin/automysqlbackup /etc/automysqlbackup/rh.conf
2Parsed config file "/etc/automysqlbackup/automysqlbackup.conf"
3
4grep: /home/icasimpan/.my.cnf: No such file or directory
5grep: /home/icasimpan/.my.cnf: No such file or directory
6# Checking for permissions to write to folders:
7base folder /var/lib ... exists ... ok.
8backup folder /var/lib/automysqlbackup ... exists ... writable? yes. Proceeding.
9checking directory "/var/lib/automysqlbackup/daily" ... exists.
10checking directory "/var/lib/automysqlbackup/weekly" ... exists.
11checking directory "/var/lib/automysqlbackup/monthly" ... exists.
12checking directory "/var/lib/automysqlbackup/latest" ... exists.
13checking directory "/var/lib/automysqlbackup/tmp" ... exists.
14checking directory "/var/lib/automysqlbackup/fullschema" ... exists.
15checking directory "/var/lib/automysqlbackup/status" ... exists.
16
17# Testing for installed programs
18mysql ... found.
19mysqldump ... found.
20gzip ... found.
21
22# Parsing databases ... Note: Parsed config file /etc/automysqlbackup/rh.conf.
23Error: The mysql server is empty, i.e. no databases found. Check if something is wrong. Exiting.
24
25###### WARNING ######
26Errors reported during AutoMySQLBackup execution.. Backup failed
27Error log below..
28ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Issue: enviroment variable is still yours and not root's. since as you can see above, it's looking from your home directory. You can either do the following:
or