Badri - 2012-09-04

Hi All,

I'm using the latest version of automysqlbackup that supports differential backup of mysql database.

When I enable the differential backup by CONFIG_mysql_dump_differential='yes' in the conf file and run the backup,
I get the following errors. But by disabling it, it runs fine and makes backup properly.

Daily Backup of Database ( mysql )
## Reading in Manifest file
Corrupted line: md5sum          diff_id         rel_id  0       db      mysql
Corrupted line: md5sum          diff_id         rel_id  0       db      mysql
.
.
Number of manifest entries: 0
Corrupted line: md5sum          diff_id         rel_id  0       db      mysql
Corrupted line: md5sum          diff_id         rel_id  0       db      mysql
Corrupted line: md5sum          diff_id         rel_id  0       db      mysql
.
.
.
----------------------------------------------------------------------
Backup End Time Tue Sep  4 14:30:24 IST 2012
======================================================================
Total disk space used for backup storage...
Size - Location
856K /tmp/automysql/backup
======================================================================
###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mktemp: too few X's in template `/tmp/automysql/backup/daily/testdb/daily_testdb_2012-09-04_14h30m_Tuesday_XXXXXXXX.sql.gz'
/usr/local/bin/automysqlbackup: line 713: : No such file or directory
mysqldump: Got errno 32 on write
md5sum: : No such file or directory
cp: cannot stat `': No such file or directory

Also I have another quick question. When running the backup in normal mode (disabling differential backup mode),
I see the backup files for a db are consuming same size.

# du -sh *
136K    daily_mysql_2012-09-04_14h31m_Tuesday.sql.gz
136K    daily_mysql_2012-09-04_14h45m_Tuesday.sql.gz
136K    daily_mysql_2012-09-04_14h46m_Tuesday.sql.gz

As per incremental backup model, one file should be of full size and rest two should be less than 136K. I'm wondering
why all the backup files are consuming full size. (No data in mysql db is changed while taking those three backup of mysql db)

Any insight on how to make this properly work as incremental backup model would be much appreciated.