Tutorial CRM - Database Management

>> Back to Tutorials Index

The Database Management Utility is used to create the default database structure needed for the CRM2 system. It can also be used for administrative tasks like taking periodic database backups.


Settings Tab


Description

Fill in the Database name, Database Server name, Database User Name and Database User Password. These are required fields. Optionally if the MySQL server is installed locally (on this computer) then also select the path to the programs as shown. Click SAVE when all fields have been filled.


Restore Tab


Description

The Import Tab area is used to restore a database from a backup file. Select the backup file.


Restore - Create Database


Description

During Restore, you have an option to create a fresh database. Check this option.


Warning - Create Database


Description

Selection of the "Create Database" option will display a warning. Click OK to continue.


Restore - Database Root password


Description

Fill in the MySQL database root password. This is required.


Restore - Completed


Description

The above notification is shown when the Restore process is completed.


Backup Tab


Description

The Backup area allow you to take database backups. Select the backup file folder. This backup folder path is saved between application restarts. During the next invocation the file name is automatically generated and you only have to ckick the START button to initiate the Backup process.


Backup - Completed


Description

The above notification is displayed when the Backup process has been completed.