PDA

View Full Version : Incrementals Not Working



BigBirdy
May 7th, 2009, 10:39 AM
Running the latest ZRM on CentOS 5x. Full backups work fine, but incrementals do not and when the job starts, doing an incremental on the local machine, it keeps asking for a mysql password? This does not make sense. Binary logging is enabled. What am I missing here ?


root@penguin:~# mysql-zrm-scheduler --now --backup-set Penguin-Inc
schedule:INFO: ZRM for MySQL Community Edition - version 2.1
Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
backup:INFO: ZRM for MySQL Community Edition - version 2.1
Penguin-Inc:backup:INFO: START OF BACKUP
Penguin-Inc:backup:INFO: PHASE START: Initialization
Penguin-Inc:backup:INFO: The quick backup-type is supported only for snapshot backups. Setting backup-type to 'regular'
Penguin-Inc:backup:INFO: Mail address: root@localhost is ok
Penguin-Inc:backup:INFO: ZRM Temporary configuration file = /etc/mysql-zrm/Penguin-Inc/tmp6wgVa.conf
Penguin-Inc:backup:INFO: {
Penguin-Inc:backup:INFO: verbose=1
Penguin-Inc:backup:INFO: retention-policy=14D
Penguin-Inc:backup:INFO: all-databases=1
Penguin-Inc:backup:INFO: destination=/mnt/Shared/Backups/Databases
Penguin-Inc:backup:INFO: password=******
Penguin-Inc:backup:INFO: backup-mode=logical
Penguin-Inc:backup:INFO: rss-header-location=/etc/mysql-zrm/
Penguin-Inc:backup:INFO: backup-type=regular
Penguin-Inc:backup:INFO: user=stork
Penguin-Inc:backup:INFO: copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl
Penguin-Inc:backup:INFO: quiet=0
Penguin-Inc:backup:INFO: backup-level=1
Penguin-Inc:backup:INFO: webserver-url=http://192.168.1.3/Content/Reports/ZRM-Reports/
Penguin-Inc:backup:INFO: mailto=root@localhost
Penguin-Inc:backup:INFO: html-reports=backup-status-info, backup-performance-info, backup-app-performance-info
Penguin-Inc:backup:INFO: host=penguin.myserver.ca
Penguin-Inc:backup:INFO: html-report-directory=/var/www/html/Content/Reports/ZRM-Reports/
Penguin-Inc:backup:INFO: compress=
Penguin-Inc:backup:INFO: }
Penguin-Inc:backup:INFO: Getting mysql variables
Penguin-Inc:backup:INFO: mysqladmin --user="stork" --password="*****" --host="penguin.myserver.ca" variables
Penguin-Inc:backup:INFO: datadir is /var/lib/mysql/
Penguin-Inc:backup:INFO: mysql_version is 5.1.34-community-log
Penguin-Inc:backup:INFO: InnoDB data file are /var/lib/mysql/ibdata1
Penguin-Inc:backup:INFO: InnoDB log dir is /var/lib/mysql/
Penguin-Inc:backup:INFO: backup set being used is Penguin-Inc
Penguin-Inc:backup:INFO: backup-set=Penguin-Inc
Penguin-Inc:backup:INFO: backup-date=20090507113527
Penguin-Inc:backup:INFO: mysql-server-os=Linux/Unix
Penguin-Inc:backup:INFO: backup-type=regular
Penguin-Inc:backup:INFO: host=penguin.myserver.ca
Penguin-Inc:backup:INFO: backup-date-epoch=1241721327
Penguin-Inc:backup:INFO: retention-policy=14D
Penguin-Inc:backup:INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 2.1
Penguin-Inc:backup:INFO: mysql-version=5.1.34-community-log
Penguin-Inc:backup:INFO: backup-directory=/mnt/Shared/Backups/Databases/Penguin-Inc/20090507113527
Penguin-Inc:backup:INFO: backup-level=1
Penguin-Inc:backup:INFO: PHASE END: Initialization
Penguin-Inc:backup:INFO: PHASE START: Running pre backup plugin
Penguin-Inc:backup:INFO: Executing pre-backup-plugin
Penguin-Inc:backup:INFO: PHASE END: Running pre backup plugin
Penguin-Inc:backup:INFO: PHASE START: Flushing logs
Penguin-Inc:backup:INFO: Flushing the logs
Penguin-Inc:backup:INFO: mysqladmin --user="stork" --password="*****" --host="penguin.myserver.ca" flush-logs
Penguin-Inc:backup:INFO: Getting master logname using command mysql --user="stork" --password="*****" --host="penguin.myserver.ca" -e "show master status"
Penguin-Inc:backup:INFO: PHASE END: Flushing logs
Penguin-Inc:backup:INFO: PHASE START: Creating incremental backup
Penguin-Inc:backup:INFO: Getting list of binary logs using command mysql --user="stork" --password="*****" --host="penguin.myserver.ca" -e "show master logs"
Penguin-Inc:backup:WARNING: No last backup dir
mysql@penguin.myserver.ca's password: