General Info

h1. How to restore Redmine backup

This restoration involves 2 parts, first part is to restore the application data; second part is to restore the <code>Redmine</code> database.

_Steps (Part 1 of 2):_

# obtain the backup location from [[How to backup Redmine]]

# in order to restore the <code>Redmine</code>, extract the whole backup to a temporary location and search for this folder:

<pre>

opt/redmine-x.x.x

</pre>

# copy the folder, <code>redmine-x.x.x</code> and then paste it into:

<pre>

/opt

</pre>

# change the <code>folder owner</code> to:

<pre>

$ chown -R redmine:redmine /opt/redmine-x.x.x

</pre>

# done

_Steps (Part 2 of 2):_

# search for this file, *redmine_backup.sql* in the extracted backup folder:

<pre>

opt/db_bak

</pre>

# ensure the following ports are unoccupied:

** 50000

** 3001

** 3002

** 3690

** 3007

# login as *redmine* user and then <code>cd</code> to the <code>Redmine</code> folder:

<pre>$ cd /opt/redmine-x.x.x</pre>

# execute the following script to start the <code>Redmine</code>:

<pre>$ ./ctlscript.sh</pre>

# if started without any error, execute the following script to restore the <code>Redmine</code> database:

<pre>

$ ./use_redmine

$ mysql -u root -p bitnami_redmine < redmine_backup.sql

</pre>

** _refer to the server_login.xls to get the database password_

# done.