Project

General

Profile

How to take redmine database backup daily?

Added by Madan Mohan Reddy A over 12 years ago

How to take redmine database backup daily?


Replies (6)

RE: How to take redmine database backup daily? - Added by Yuriy Vidineev over 12 years ago

Just use any tool to backup redmine database (mysqldump fo MySQL for example)

RE: How to take redmine database backup daily? - Added by Ramon Risman over 12 years ago

Script for daily backups:

  1. Database
    /usr/bin/mysqldump -u <username> -p<password> <redmine_database> | gzip > /path/to/backup/db/redmine_`date +%y_%m_%d`.gz
  1. Attachments
    rsync -a /path/to/redmine/files /path/to/backup/files
    (1-6/6)