How to backup redmine?

Added by ying chen over 4 years ago

  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

I have no idea how to use the instructions,can anyone teach me how to do it?

Replies (7)

RE: How to backup redmine? - Added by Thomas Lecavelier over 4 years ago

Windows user I presume?

RE: How to backup redmine? - Added by David P over 4 years ago

ying, do you still need help with this? if so, let me know.

RE: How to backup redmine? - Added by Michael Aye over 4 years ago

I think more than these 2 backup script lines would be very useful.
Something like general export/backup - import/restore instructions for Redmine.
Could someone type this together please? Shouldn't be too much work for the professionals...

RE: How to backup redmine? - Added by Amit Aggarwal about 4 years ago

Hi,

Is there a backup script for windows ? Otherwise, please tell how to use these scripts...!
I have installed redmine using BITNAMI installer.

RE: How to backup redmine? - Added by Tomás Rinke over 3 years ago

hi, for ubuntu server you can do:

First: check those two command lines are working for your environment, watch out user/groups and file permissions
Second: create a script under /usr/local/bin with the working commands. (you can create one script per command) for example:

db_redmine_backup and files_redmine_backup

then test it by running the scripts
Third: once working, edit with a sudo user the file /etc/crontab by adding one or two lines at the end, you should understand what to put when you see the file, for example:
0 7 * * * adminuser /usr/bin/db_redmine_backup -> for a daily backup at 7 am

Fourth: you can edit the script to make an ftp o rpc to another machine

RE: How to backup redmine? - Added by Lawrence Ferreira over 3 years ago

ying chen wrote:

  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

I have no idea how to use the instructions,can anyone teach me how to do it?

Remember there is no space between -p and the password...
Should be something like that:

-ppassword

RE: How to backup redmine? - Added by Peter Theill over 2 years ago

I wrote a script for backing up Redmine on Google Storage. It might be of interest for some of you. Read article from my blog at:

http://commanigy.com/blog/2010/10/27/how-to-backup-redmine-on-google-storage

(1-7/7)