The dump of the database is created 7:00 am every day by crontab.It uses crontab entry on pinger machine for pinger user. The database dump is saved for one week i.e. at any particular time the database would have one week of database back up. The backup is created by a script called backuptulip.sh which is deployed at
/swaparea/mysql_backup/backuptulip.sh
The script calculates the day of week and creates a sub folder with that in mysql_backup directory. The data data dump is created and then gzip of data is saved in the day of week folder.
If there is some problem with the backup , I have created a script recoverTulipData.pl. This script can help to recover the previous day from sites.xm. The script is deployed at
/afs/slac/package/pinger/tulip/recoverTulipData.pl