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. |