PDA

View Full Version : Error when running mysql-zrm-scheduler



rkempf
November 16th, 2006, 12:34 PM
Hello from a newbie,

I just installed zmanda and am trying a test using the default mysql test database.

I believe that I have the conf file setup correctly:

backup-level=0
backup-mode=logical
destination=/backups/mysql-zrm
retention-policy=10D
compress=1
compress-plugin=/usr/bin/bzip2
databases=test
user="backup-user"
password="password"
socket=/tmp/mysql.sock
mysql-binlog-path="/var/log/mysql"
verbose=1

Here is the command I am running:
mysql-zrm-scheduler --now --backup-set dailyrun

Unfortunately I can't seem to get past this error.

ERROR: Register backup in dailyrunfailed

INFO: backup-status=Backup done but with errors
INFO: Backup done but with errors
ERROR: /usr/bin/mysql-zrm did not finish successfully

Is there something I need to set in the conf file or elsewhere to fix this error.

I can provide more info if necessary. I am trying to limit the verbosity of my post.

Thanks in advance.

ReedK

paddy
November 16th, 2006, 01:00 PM
Do you have a backup set?

Where is mysql-zrm.conf located? /etc/mysql-zrm/<backup set name>/mysql-zrm.conf?
Can you check if this directory is writable?

Thanks,
Paddy

rkempf
November 16th, 2006, 01:09 PM
thanks for the reply.

The mysql-zrm.conf is located in /etc/mysql-zrm/dailrun/mysql-zrm.conf

under that directory, I created a directory called last_backup as I was going to put the backups under there. I then switched the location to /backups/mysql-zrm and got the aforementioned ERROR.

I removed the /etc/mysql-zrm/dailyrun/last_backup directory and my backup then succeeded.

I am glad it works but am not sure why it was attempting to look down the last_backup directory. Any more help would be appreciated.

Thank you again for the prompt response.

ReedK

paddy
November 16th, 2006, 01:20 PM
"last_backup" is a reserved file name. ZRM for MySQL uses file to store internal state of backup for the backup set. So, it will create /etc/mysql-zrm/last_backup, /etc/mysql-zrm/<backup set>/last_backup files and read these files.

So, ZRM for MySQL users should not create a file or directory called "last_backup" in
/etc/mysql-zrm directory tree.

Paddy

rkempf
November 16th, 2006, 01:28 PM
Excellent, thanks for clearing that up.

Reedk