Changes

Jump to: navigation, search

Restore IMSMA Backup on Server

1,379 bytes added, 10:34, 17 December 2017
no edit summary
{{note| If you are restoring your IMSMA data due to a system crash, you will first want to [[Install IMSMANG Version 6|re-install IMSMA]] and its supporting applications.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 dataon 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 IMSMA {{IMSMANG}} server and , all IMSMA clients and all connections to the {{IMSMANG}} database from e.g. Navicat have been shut downdisconnected.</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>
<li>Select the IMSMA [[Image:Backup and Restore optionmenu.</li>png|center]]<li>Select the Start '''Restore option'''.</li>:The IMSMA Restore window displays.</ol>[[Image:fig186Restore.png|center|500px400px|''Figure 186. IMSMA Restore window'']]
<div align="center">
''IMSMA Restore window''
</div>
<ol start = "7"><li>Click In the IMSMA Restore window, click the [[Image:DestDir.png]] button.</li>:<li>The Open window displays.<li>From the Open window:</li><ol type="a">
<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>
[[Image:Restore2.png|center|400px|''IMSMA Restore window'']]
<div align="center">
''IMSMA Restore window''
</div>
{{note| When selecting <li>In the directory from which you would like to restore your IMSMA data'''Include the Following''' section, be sure to select each available component in the directory that backup folder is named marked with [[Image:CheckedBoxIcon.png]]. Uncheck the date and time the backup was performedcheckbox next to each component you do not want to restore. }}</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 Open '''Restore''' button.</li>:The name <li>First the files outside of the directory displays in database will be restored and at 20% the IMSMA Restore will ask for the Select password.</li>{{Note| It is possible to change the directory you want database password with SQL software. Note that ''C:\IMSMAng\trayLauncher\TrayLauncher.properties'' also needs to restore from fieldbe updated.}}<li>Enter the database password.[[Image:Imsma pwd2.png|center|400px]]</olli> <li>In Click the Include '''OK''' button.</li> <li>The IMSMA Restore will continue and now the Following section, each item that database is available to be restored is checked by defaultfrom the backup. Uncheck the checkbox (</li>[[Image:CheckedBoxIconRestore3.png|center|400px]]) next to each item you do not want to restore.</li>:Items that are disabled were not backed up to the file you selected to restore and cannot be included. If you do not check any items, only the IMSMA database <li>The attachments will be restoredat 90%.</li>[[Image:Restore4. png|center|400px]]</li><li>Click the '''OK''' button. [[Image:Restore buttonconfirm.png|center|250px]]</li> :A window displays one <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 messages listed in TableIMSMA application and therefore needs to be upgraded to the same version as the IMSMA application.</li></ol>
If you see this message {{Warning | It meansPlease enter Password Continue is not possible to the next stepupgrade a database of version 1 - 5.No action taken08. Database restore can only be performed on the Server04 by restoring it with version 6. The IMSMA database can only be restored on the server and 0. Contact your computer is configured as [[Information Management Team | GICHD IM advisor]] if you would like to upgrade a client, not a serverdatabase of version 1 - 5.08. Although other data can be restored on a client computer, you requested 04 to restore the IMSMA database only or no other data was available, so no data was restoredversion 6.0. }}
Restore Complete. Please note that the IMSMA database was not restored. Database restore can only be performed on the Server.
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.
If you see these messages, your computer is configured as an IMSMA client and it is not possible to restore the database.
{| class="wikitable"
|-
| [[Image:Client restore database error.png|center|400px]]
| [[Image:Client restore confirm.png|center|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 Manage Information}}
{{NavBox How To Backup}}[[Category:NAA]]
6,632
edits

Navigation menu