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