NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{note| If you are restoring your IMSMA data due to a system crash, you will first want to reinstall IMSMA and its supporting applications. For more information, see the IMSMA 4.01.02 Installation Guide for detailsTOC right}} {{note| If you are running IMSMA in a networked environmentclient/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>
<div align="center">
''IMSMA Restore window''
</div>
<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 | 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>
|-
| align="center" colspan="2" | '''Table 53[[Image:Client restore database error. Backup File Descriptions'''png|-center| width="125pt" | '''Backup File'''400px]]| width="375pt" | '''Description'''|-| GIS Database || Contains all the GIS data such as map icons and their locations that appear in the map display. The file is located in the IMSMA_HOME\client\gis\sandbox\[active map]\map directory folder[Image:Client restore confirm. png|-center| Map Data || Contains all the background geographical information (for example, rivers) that appears in the map display. The file is located in the IMSMA_HOME\server\gis\maps\[active map400px]] folder.|-| Form Template || Contains unpublished field report templates that were created using the Form Designer and saved on the local computer. The file is located in the IMSMA_HOME\client\FormTemplates\MyTemplates folder.|-| Report Template || Contains unpublished report templates that were created using the External Reporting Tool (iReport) and saved on the local computer. The file is located in the IMSMA_HOME\iReport\IMSMA Reports folder.|-| Translations || Contains the ITerms_XX.properties, IMessage_XX.properties, and UIString_XX.properties files. The files are located in the IMSMA_HOME\client\resources\com\fgm\imsma\lexicon directory and the IMSMA_HOME\client\resources\com\fgm\util directory.
|}
==SQL Views after restore==__NOEDITSECTION__
Since the views may build on other views it is not possible to know in which order they should be restored. Therefore the Restore functionality restores the SQL views as tables and after the restore is complete convert them to SQL views. If you still see any of your SQL views as tables after the restore, there is something wrong with your SQL views. The most common errors are:
* the SQL views are created / owned by another user than imsma
* the SQL syntax is not correct
* the SQL view is referring to another SQL view that does not exist anymore.
