Support for MySQL Database

Support for MySQL Database

Dear Users,

Please note that the support for MySQL database will be removed from Jun 2017.

The main reason to stop supporting MYSQL database is  that, we are working on Mickey lite framework migration. ServiceDeskPlus-MSP is built on top of Manage Engine's proprietary framework. This framework enables the flexibility to use the desired database. Currently, we are in the process of upgrading this framework for better stability and to include advanced features.  Providing support for the older databases on the framework turns out to be a complex task and also affects the performance and scalability of the product. 

As you know  v4.1.18 and v5.1.0 are the supported MYSQL versions, supporting these older databases would become a huge problem during the time of frame work migration.

The following is the procedure to migrate your ServiceDesk Plus database from MYSQL to PGSQL.

Step 1: Stop the ManageEngine ServiceDeskPlus-MSP service.

Step 2: Take a backup of the existing data in the application

From the command prompt, go to [ServiceDeskPlus-MSP]\bin directory and execute the backUpData.bat command to start the data backup.

cmd> [ServiceDeskPlus-MSP]\bin

cmd> backUpData.bat

This backup will be stored under the Backup folder in ServiceDeskPlus-MSP Home directory.

Step 3: Install a fresh version of ServiceDeskPlus-MSP of the same build. A fresh install will have PGSQL as a default database. 

You can download the appropriate builds from the below link. 


Step 4 : Once after installing the build, start and stop the application service once for the new tables to get created in the database.

Step 5: Now Restore the Backup taken in the second step. To restore run the command prompt as an administrator. Now go to  ServiceDeskPlus-MSP]\bin   and execute R estoreData.bat , browse and give the latest backup taken. Once the restore is complete you will get a pop up saying Restoration completed successfully. 

Regards,
Gopinath J
Direct Support Number : +1-408-352-9131
Refer here for :  Issues Fixed  |  Road Map Features  |  Useful Documents
              New to ADManager Plus?

                New to ADSelfService Plus?