Hi all,
I just noticed this really wierd behaviour. I have a script called
/etc/backup.mysql which backs up my databases using mysqldump. The contents
of the file are:
mysqldump --opt mysql | gzip > /home/backup/`date '+%Y%m%d'`-mysql.gz
mysqldump --opt twig | gzip > /home/backup/`date '+%Y%m%d'`-twig.gz
mysqldump --opt vh001 | gzip > /home/backup/`date '+%Y%m%d'`-vh001.gz
mysqldump --opt vh108 | gzip > /home/backup/`date '+%Y%m%d'`-vh108.gz
mysqldump --opt vh109 | gzip > /home/backup/`date '+%Y%m%d'`-vh109.gz
Now this script is called from one that runs every monday to saturday and it
seems to work perfectly.
The same script is called in the same manner from one that runs only on
sundays and the backup files get created but are empty. All of them!
Running the above script manually on a Sunday works fine.
Both the calling scripts mentioned above run at the same time of day (04:22)
so I cannot see why mysqldump is giving empty archives each Sunday.
System is a RH 6.1 running mySQL 3.22.32
Any ideas?
+-----------------------+---------------------------------+
| Peter Kiem | E-Mail : <[EMAIL PROTECTED]> |
| Zordah IT | Mobile : +61 0418 798 121 |
| IT Consultancy & | WWW : www.zordah.net |
| Internet Hosting | ICQ : "Zordah" 866661 |
+-----------------------+---------------------------------+
The Rules Have Changed...Be paid to Surf the Web!
http://au.nz.alladvantage.com/go.asp?refid=OMP682
_______________________________________________
Redhat-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list
