Database Info/mysql backup scripts details

From Informatics

Jump to: navigation, search

Contents

mysql1.c2b2.columbia.edu

  • MySQL version: 5.6.22
  • Backup program: mysqldump
  • Backup location: /ifs/db/backup/mysql1
  • Backup script: /ifs/db/backup/mysql1/backup_mysql1.sh
  • MySQL user running script:
  • MySQL user password:
  • OS user executing script: mysql
  • cron details: 
*/5 * * * * /bin/sh /var/lib/mysql/rotate_log.sh
00 04 * * 4 /bin/sh /ifs/db/backup/mysql1/backup_mysql1.sh

mysql3.c2b2.columbia.edu

  • MySQL version: 5.1.34
  • Backup program: mysqldump
  • Backup location: /ifs/db/backup/mysql3
  • Backup script: /ifs/db/backup/mysql3/backup_mysql3.sh
  • MySQL user running script: dbabackup
  • MySQL user password: KeEpMeSecure4u
  • OS user executing script: mysql
  • cron details: 
########### run backup_mysql3.sh every day #######
00 02 * * * /bin/sh /ifs/db/backup/mysql3/backup_mysql3.sh
########## delete backup directories older than specified number of days ###########
45 03 * * * /usr/bin/find /ifs/db/backup/afdev -type d -mtime +30 -exec rm -rv {} \;
50 03 * * * /usr/bin/find /ifs/db/backup/afdev2 -type d -mtime +30 -exec rm -rv {} \;
55 03 * * * /usr/bin/find /ifs/db/backup/saecdb -type d -mtime +45 -exec rm -rv {} \;
40 03 * * * /usr/bin/find /ifs/db/backup/acdb -type d -mtime +30 -exec rm -rv {} \;
30 03 * * * /usr/bin/find /ifs/db/backup/cucaarray -type d -mtime +30 -exec rm -rv {} \;
30 03 * * * /usr/bin/find /ifs/db/backup/isis -type d -mtime +30 -exec rm -rv {} \;
00 04 * * * /usr/bin/find /ifs/db/backup/mysql3 -type d -mtime +60 -exec rm -rv {} \;

saecdb.c2b2.columbia.edu

  • MySQL version: 5.0.95
  • Backup program: mysqldump
  • Backup location: /ifs/db/backup/saecdb
  • Backup script: /ifs/db/backup/mysql1/backup_saecdb.sh
  • MySQL user running script: dbabackup
  • MySQL user password: KeEpMeSecure4u
  • OS user executing script: mysql
  • cron details: 
00 03 * * * /bin/sh /ifs/db/backup/saecdb/backup_saecdb.sh

afdev.c2b2.columbia.edu

  • MySQL version: 5.0.95
  • Backup program: mysqldump
  • Backup location: /ifs/db/backup/afdev
  • Backup script: /ifs/db/backup/afdev/backup_afdev.sh
  • MySQL user running script: dbabackup
  • MySQL user password: KeEpMeSecure4u
  • OS user executing script: mysql
  • cron details: 
40 02 */5 * * /bin/sh /ifs/db/backup/afdev/backup_afdev.sh

afdev2.c2b2.columbia.edu

  • MySQL version: 5.0.95
  • Backup program: mysqldump
  • Backup location: /ifs/db/backup/afdev2
  • Backup script: /ifs/db/backup/afdev2/backup_afdev2.sh
  • MySQL user running script: dbabackup
  • MySQL user password: KeEpMeSecure4u
  • OS user executing script: mysql
  • cron details: 
######## backup all mysql databases once per week ###########
00 04 */5 * * /bin/sh /ifs/db/backup/afdev2/backup_afdev2.sh

isis.c2b2.columbia.edu

  • MySQL version: 5.0.45
  • Backup program: mysqldump
  • Backup location: /ifs/db/backup/isis
  • Backup script: /ifs/db/backup/isis/backup_isis.sh
  • MySQL user running script: dbabackup
  • MySQL user password: KeEpMeSecure4u
  • OS user executing script: mysql
  • cron details: 
######## backup mysql databases every five days ###########
10 03 */5 * * /bin/sh /ifs/db/backup/isis/backup_isis.sh
Retrieved from "http://wiki.c2b2.columbia.edu/informatics/index.php/Database_Info/mysql_backup_scripts_details"
Personal tools