NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
To restore IMSMA data on the server:
<ol>
<li>Are your '''really''' sure that you would like to write over the existing database on the server?</li>
<li>Do you have backup that contains all '''attachments'''?</li>
<li>Before beginning the restoration process, verify that the {{IMSMANG}} server, all IMSMA clients and all connections to the {{IMSMANG}} database from e.g. Navicat have been disconnected.</li>
<li>If the IMSMA Control Centre icon is not already displayed in the lower, right corner of your Window’s desktop, double-click the IMSMA Tray Launcher icon on your computer’s desktop.</li>
<li>The Open window displays.</li>
<li>Navigate to the directory from which you would like to restore your IMSMA data.</li>
<li>Click the '''Open''' button.</li>
<li>The path of the folder displays in the ''Select the directory you want to restore from'' field.</li>
{{Note | Components that are disabled were not included in the IMSMA backup that you selected to restore. If you do not check any components, only the IMSMA database and any attachments will be restored. }}
{{Warning | If the backup folder that you are about to restore contains the folder Backup_YYYY_MM_DD_HH_MM_SS\server\attachments then all your existing '''attachments''' on the server will be '''deleted''' and replaced with what is in Backup_YYYY_MM_DD_HH_MM_SS\server\attachments. This behaviour also applies when Backup_YYYY_MM_DD_HH_MM_SS\server\attachments is empty.}}
<li>Click the '''Restore''' button.</li>
<li>First the files outside of the database will be restored and at 20% the IMSMA Restore will ask for the password.</li>
{{Note| It is possible to change the database password with SQL software. Note that ''C:\IMSMAng\trayLauncher\TrayLauncher.properties'' also needs to be updated.}}
<li>Enter the database password.
[[Image:Imsma pwd2.png|center|400px]]</li>
<li>The IMSMA Control Centre closes. The IMSMA Control Centre needs to be closed because the IMSMA database restored may be of an earlier version than the current version of the IMSMA application and therefore needs to be upgraded to the same version as the IMSMA application.</li>
</ol>
{{Warning | It is not possible to upgrade a database of version 1 - 5.08.04 by restoring it with version 6.0. Contact your [[Information Management Team | GICHD IM advisor]] if you would like to upgrade a database of version 1 - 5.08.04 to version 6.0.}}
If you see these messages, your computer is configured as an IMSMA client and it is not possible to restore the database.
* the SQL view is referring to another SQL view that does not exist anymore.
{{NavBox How To BackupManage Information}}
[[Category:ELRNAA]]
