Project

General

Profile

How to restore Redmine backup » History » Version 3

chin-yeh, 03/12/2012 02:26 PM

1 1 chin-yeh
h1. How to restore Redmine backup
2 2 chin-yeh
3 3 chin-yeh
> see also http://wiki.bitnami.org/Applications/BitNami_Redmine
4
5 2 chin-yeh
This restoration involves 2 parts, first part is to restore the application data; second part is to restore the <code>Redmine</code> database.
6
7
_Steps (Part 1 of 2):_
8
# obtain the backup location from [[How to backup Redmine]]
9
# in order to restore the <code>Redmine</code>, extract the whole backup to a temporary location and search for this folder:
10
<pre>
11
opt/redmine-x.x.x
12
</pre>
13
# copy the folder, <code>redmine-x.x.x</code> and then paste it into:
14
<pre>
15
/opt
16
</pre>
17
# change the <code>folder owner</code> to:
18
<pre>
19
$ chown -R redmine:redmine /opt/redmine-x.x.x
20
</pre>
21
# done
22
23
_Steps (Part 2 of 2):_
24
# search for this file, *redmine_backup.sql* in the extracted backup folder:
25
<pre>
26
opt/db_bak
27
</pre>
28
# ensure the following ports are unoccupied:
29
** 50000
30
** 3001
31
** 3002
32
** 3690
33
** 3007
34
# login as *redmine* user and then <code>cd</code> to the <code>Redmine</code> folder:
35
<pre>$ cd /opt/redmine-x.x.x</pre>
36
# execute the following script to start the <code>Redmine</code>:
37
<pre>$ ./ctlscript.sh</pre>
38
# if started without any error, execute the following script to restore the <code>Redmine</code> database:
39
<pre>
40
$ ./use_redmine
41
$ mysql -u root -p bitnami_redmine < redmine_backup.sql
42
</pre>
43
** _refer to the server_login.xls to get the database password_
44
# done.