Difference between revisions of "Restore IMSMA Backup on Server"
From IMSMA Wiki
| Line 35: | Line 35: | ||
<li>Click the '''Restore''' button.</li> | <li>Click the '''Restore''' button.</li> | ||
<li>First the files outside of the database will be restored and at approximately 20% the IMSMA Restore will ask for the password.</li> | <li>First the files outside of the database will be restored and at approximately 20% the IMSMA Restore will ask for the password.</li> | ||
| + | {{Note| It is possible to change the database password with SQL software.}} | ||
<li>Enter the database password. | <li>Enter the database password. | ||
| − | |||
[[Image:Imsma pwd.png|center|300px]]</li> | [[Image:Imsma pwd.png|center|300px]]</li> | ||
<li>Click the '''OK''' button.</li> | <li>Click the '''OK''' button.</li> | ||
Revision as of 13:03, 10 March 2016
Contents |
 |
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:
- 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.
- 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.
- Right-click the IMSMA Control Centre icon that is displayed in the lower, right corner of your Window’s desktop.
- Select Restore.
- In the IMSMA Restore window, click the
button. - The Open window displays.
- Navigate to the directory from which you would like to restore your IMSMA data.
- Click the Open button.
- The path of the folder displays in the Select the directory you want to restore from field.
- In the Include the Following section, each available component in the backup folder is marked with
. Uncheck the checkbox next to each component you do not want to restore. - Click the Restore button.
- First the files outside of the database will be restored and at approximately 20% the IMSMA Restore will ask for the password.
- Enter the database password.
- Click the OK button.
- The IMSMA Restore will continue and now the database is restored from the backup.
- Click the OK button.
- The TrayLauncher/IMSMA Control Centre closes. The TrayLauncher 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.
IMSMA Restore window
| |
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. |
IMSMA Restore window
| |
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 will be restored. |
| |
It is possible to change the database password with SQL software. |
If you see these messages, your computer is configured as an IMSMA client and it is not possible to restore the database.
 |
 |
SQL Views after restore
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.
