Changes

Jump to: navigation, search

Restore IMSMA Backup on Server

1,345 bytes added, 10:34, 17 December 2017
no edit summary
{{TOC right}}
{{note| If you are running IMSMA in a client/server configuration, the following procedures should be performed on the IMSMA '''server'''. }}
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>Right-click the IMSMA Control Centre icon that is displayed in the lower, right corner of your Window’s desktop.</li>
[[Image:Backup Restore menu.png|center]]<li>Select '''IMSMA Backup and Restore > Restore'''.</li></ol>
[[Image:Restore.png|center|400px|''IMSMA Restore window'']]
</div>
<ol start = "5">
<li>In the IMSMA Restore window, click the [[Image:DestDir.png]] button.</li>
<li>From the The Open window:displays.</li><ol type="a">
<li>Navigate to the directory from which you would like to restore your IMSMA data.</li>
 
{{note| When selecting the directory from which you would like to restore your IMSMA data, be sure to select the directory that is named with the date and time the backup was performed. }}
 
<li>Click the '''Open''' button.</li>
:<li>The name path of the directory folder displays in the ''Select the directory you want to restore from '' field.</olli>
[[Image:Restore2.png|center|400px|''IMSMA Restore window'']]
<div align="center">
</div>
<li>In the '''Include the Following''' section, each item that is available to be restored component in the backup folder is checked by default. Uncheck the checkbox (marked with [[Image:CheckedBoxIcon.png]]) . Uncheck the checkbox next to each item component you do not want to restore.</li>:Items {{Note | Components that are disabled were not backed up to included in the file IMSMA backup that you selected to restore and cannot be included. If you do not check any itemscomponents, 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>Click the '''OK''' button.</li> <li>The IMSMA Restore will continue and now the database is restored from the backup.</li>[[Image:A window displays one Restore3.png|center|400px]]</li><li>The attachments will be restored at 90%.</li>[[Image:Restore4.png|center|400px]]</li><li>Click the '''OK''' button. [[Image:Restore confirm.png|center|250px]]</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 messages: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.
{| class="wikitable"
|-
! If you see this message !! It means |-| Please enter Password|| Continue to the next step.|-| No action taken. Database [[Image:Client restore can only be performed on the Serverdatabase error.png|center| The IMSMA database can only be restored on the server and your computer is configured as a client, not a server. Although other data can be restored on a client computer, you requested to restore the IMSMA database only or no other data was available, so no data was restored. 400px]]|-| Restore Complete. Please note that the IMSMA database was not restored. Database [[Image:Client restore can only be performed on the Serverconfirm.png|center| The IMSMA database can only be restored on the server and your computer is configured as a client, not a server. The other data you requested to restore has been restored, but the IMSMA database has not been restored. 400px]]
|}
<li>Enter the database password.</li>==SQL Views after restore==__NOEDITSECTION__ <li>Click Since the '''OK''' button.</li> :Your IMSMA data views may build on other views it is not possible to know in which order they should be restored from . Therefore the Restore functionality restores the backupSQL views as tables and after the restore is complete convert them to SQL views. When If you still see any of your SQL views as tables after the restore completes, a message window displaysthere is something wrong with your SQL views. The most common errors are:<li>Click * the '''OK''' button. <SQL views are created /li>owned by another user than imsma:The message window closes and * the SQL syntax is not correct* the tray launcher closesSQL view is referring to another SQL view that does not exist anymore.</ol>
{{NavBox How To BackupManage Information}}
[[Category:ELRNAA]]
6,632
edits

Navigation menu