Feature #542

Redmine automated backup/restore

Added by Sam McCoy almost 14 years ago. Updated over 9 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Administration
Target version:-
Resolution:

Description

I think it would be great if there was an automated backup button that would generate a backup of all the
projects/files.

An automated restore function would be nice as well. This way users could backup the projects, move to a new server,
install redmine and then restore the backup.

History

#1 Updated by Dusan Holub almost 14 years ago

+1
Feature proposed is useful not only for transfer to another server,
but also for regular backups. Missing possibility of backup/restore
prevents RubyForge from professional usage. At least some script
for backup/recovery would be nice.
Thanks!

#2 Updated by Michael Aye almost 13 years ago

+1
also for test-driving Redmine this is helpful: One could already enter some issues to see how it is, and if liked can just transfer (e.g. from a Bitnami stack) everything to a full installation.

#3 Updated by Damien Couderc over 12 years ago

+1000

I'm really surprised that so few people asked for this feature.
Does it mean than only 3 people here take care of having backups ?

#4 Updated by Damien Couderc over 12 years ago

By the way, it also could provide some hooks for plugins.

#5 Updated by Thomas Pihl over 12 years ago

Damien Couderc wrote:

+1000

I'm really surprised that so few people asked for this feature.
Does it mean than only 3 people here take care of having backups ?

I don't really think so. My understanding is that normal backup are straigt-forward and easy to implement so no-one bother to do the same thing in redmine.

If you have your code in a repo, all you have to do are:
  • mysqldump your databases to wherever you'l like to keep your backups.
  • zip/tar/similar the config and files catalog to a safe location as well

The issue (usually) is finding the safe location and to hadnle multiple generations of backup. Both those things are well handled by "real" backup software or some external scrips.

#6 Updated by Nanda P over 12 years ago

+1

For now, On Windows XP server. I created a batch file & schedule it to run every 12hrs. Its working for me. (MySQL backend)

You can use any file compression utility. I am using one called 7Zip (http://www.7-zip.org/)

REM RedMine Production Backup - please don't Delete or Modify
@ECHO OFF

path=%PATH%;C:\Program Files\MySQL\MySQL Server 5.1\bin;C:\Program Files\7-Zip\;

FOR /F "tokens=1-4 DELIMS=/ " %%F IN ('date /T') DO (set v_date=%%F%%G%%H%%I)
FOR /F "tokens=1-4 DELIMS=/ " %%F IN ('date /T') DO (set v_date1=%%G%%H%%I)
FOR /F "tokens=1-4 DELIMS=: " %%F IN ('time /T') DO (set v_time=%%F%%G%%H)
set fname=C:\RMBackup\RMDBBackup_%v_date%_%v_time%.sql
set filesZip=C:\RMBackup\RMFiles_%v_date1%_%v_time%.zip

mysqldump.exe -uUserID -pPassword --databases redmine > %fname%

@7z.exe a %filesZip% "C:\Program Files\redmine\current\files\????????????_*.*" -y -bd

#7 Updated by Damien Couderc over 12 years ago

@ Thomas :
The fact I know how to make a custom backup myself does not mean than a more reliable solution should exists.

What about if your server goes down for an hardware failure and that the new one use an higher version of the database which is incompatible with the backup files ?

It would be more professionally to have a backup feature which is database vendor insensitive, so we can make a backup on some host and restore on another one.
I already had to migrate the Redmine database at work and I can tell you it's pure hell.

This is one the aspects that prevents Redmine to be validated at work, I maintain it only for our team.

#8 Updated by Etienne Massip over 10 years ago

  • Category set to Administration

#9 Updated by paul ting over 9 years ago

REM RedMine Production Backup - please don't Delete or Modify
@ECHO OFF

path=%PATH%;C:\Program Files\MySQL\MySQL Server 5.1\bin;C:\Program Files\7-Zip\;

FOR /F "tokens=1-4 DELIMS=/ " %%F IN ('date /T') DO (set v_date=%%F%%G%%H%%I)
FOR /F "tokens=1-4 DELIMS=/ " %%F IN ('date /T') DO (set v_date1=%%G%%H%%I)
FOR /F "tokens=1-4 DELIMS=: " %%F IN ('time /T') DO (set v_time=%%F%%G%%H)
set fname=C:\RMBackup\RMDBBackup_%v_date%_%v_time%.sql
set filesZip=C:\RMBackup\RMFiles_%v_date1%_%v_time%.zip

mysqldump.exe -uUserID -pPassword --databases redmine > %fname%

@7z.exe a %filesZip% "C:\Program Files\redmine\current\files\????????????_*.*" -y -bd

how to restore?

Also available in: Atom PDF