Steps to follow Before doing MySQLUpgrade. ========================================== 1. Execute the following query manually. This will list the tables name which is having varchar column's sum is more than 21000. QUERY : SELECT table_name, SUM(character_maximum_length) AS column_len FROM information_schema.columns WHERE table_schema = AND data_type = 'varchar' GROUP BY 1 HAVING column_len > 21000; change that column which is having highest value in varchar datatype in a table E.g varchar (25000). Note : 1. Modify the varchar columns Apart from the following tables. 1. asset_inv_querybuilder 2. itcomplianceconfigdetails 3. performanceview_lookup 4. sd_querybuilder 5. sd_servicereqmaster 6. sd_servicereqmaster_backup 7. sd_servicereqmasterarchive 8. backupjobapproval 9. ldap_ou 10. sd_temp_requestid 11. configsettings I. Steps to upgrade MySQL 5.5 to MySQL 5.7 ========================================== SapphireIMS Server and MySQL Server both on same machine -------------------------------------------------------- 1. Unzip the MySQLUpgrade_V3.0.zip file. Note: Stop the SapphireIMS Service. 2. Download mysql-installer-community-5.7.17.0.msi from the following link and copy to \MySQL Msi\ folder. (https://downloads.mysql.com/archives/get/file/mysql-installer-community-5.7.17.0.msi) 3. Note down the following variable values from MySQL Server 5.5 my.ini file. Post MySQL 5.7 installation and before restoring the database backup, update the respective variable values in MySQL Server 5.7 my.ini file. i. max_connections ii. tmp_table_size iii. key_buffer_size iv. innodb_log_buffer_size v. innodb_buffer_pool_size Note: Apart from above changes, if any other parameters are customized in MySQL 5.5 my.ini file then similar changes must be done in MySQL 5.7 my.ini as well. 4. Open a new command prompt as "Run as administrator", then navigate to MySQLUpgrade.bat contains folder and then execute the MySQLUpgrade.bat file. E.g.: \MySQLUpgrade.bat Note : Execute the MySQL Upgrade from SapphireIMS installed drive. E.g. If SapphireIMS is installed in D: drive then should Run the script from D: drive itself. SapphireIMS Server and MySQL Server (Windows) on different machines ------------------------------------------------------------------- Execute MySQLUpgrade.bat on both SapphireIMS Server and MySQL Server installed machines. Note : First execute the MySQLupgrade.bat in MySQL Server installed machine, Post execute in SapphireIMS installed machine. Steps to execute MySQLUpgrade.bat on MySQL Server installed machine ------------------------------------------------------------------- 1. Unzip the MySQLUpgrade_V3.0.zip file. 2. Download mysql-installer-community-5.7.17.0.msi from the following link and copy to \MySQL Msi\ folder. (https://downloads.mysql.com/archives/get/file/mysql-installer-community-5.7.17.0.msi) 3. Note down the following variable values from MySQL Server 5.5 my.ini file. Post MySQL 5.7 installation and before restoring the database backup, update the respective variable values in MySQL Server 5.7 my.ini file. i. max_connections ii. tmp_table_size iii. key_buffer_size iv. innodb_log_buffer_size v. innodb_buffer_pool_size Note: Apart from above changes, if any other parameters are customized in MySQL 5.5 my.ini file then similar changes must be done in MySQL 5.7 my.ini as well. 4. Open a new command prompt as "Run as administrator", then navigate to MySQLUpgrade.bat contain folder and then execute the MySQLUpgrade.bat file. E.g.: \MySQLUpgrade.bat Note: Execute the MySQL Upgrade from MySQL Server installed drive. E.g. If MySQL Server is installed in D: drive then should Run the script from D: drive itself. Steps to execute MySQLUpgrade.bat on SapphireIMS Server installed machine ------------------------------------------------------------------------- 1. Unzip the MySQLUpgrade_V3.0.zip file. Note: Stop the SapphireIMS Service. 2. Download mysql-installer-community-5.7.17.0.msi from the following link and copy to \MySQL Msi\ folder. (https://downloads.mysql.com/archives/get/file/mysql-installer-community-5.7.17.0.msi) 3. Open a new command prompt as "Run as administrator", then navigate to MySQLUpgrade.bat contain folder and then execute the MySQLUpgrade.bat file. E.g.: \MySQLUpgrade.bat Note: Execute the MySQL Upgrade from SapphireIMS installed drive. E.g. If SapphireIMS is installed in D: drive then should Run the script from D: drive itself. SapphireIMS Server and MySQL Server (Linux) ------------------------------------------- Refer to the MySQL 5.5 to 5.7 Upgrade.docx to manually upgrade MySQL Server on Linux machine. MySQL Server Re-installation (Windows) -------------------------------------- In case of re-installation of MySQL Server 5.7 due to previous installation issues, follow the steps given below. 1. Uninstall MySQL Server 5.7 using control panel. 2. Uninstall MySQL community using control panel. 3. Delete the following MySQL Server 5.7 folders including their contents. i. \MySQL Server 5.7\ ii. C:\ProgramData\MySQL\MySQL Server 5.7\ 4. Refer to the MySQL 5.5 to 5.7 Upgrade.docx to manually upgrade MySQL Server. 5. Post Successful installation of MySQL 5.7 Server, delete the following MySQL Server 5.5 folders including their contents. i. \MySQL Server 5.5\ ii. C:\ProgramData\ MySQL\ MySQL Server 5.5\ 6. Uninstall MySQL community using control panel. Notes: i. Upgrade logs can be found in the following folder. \ConsoleManagement\ExternalWar\SoftwareRepository.war\MySQLUpgrade\Logs\ ii. Database backup files can be found in the following folder. \ConsoleManagement\ExternalWar\SoftwareRepository.war\MySQLUpgrade\MySQLBackup\ II. Securing MySQL Configuration (Restricting External Connections) =================================================================== For restricting external connections on MySQL server, kindly refer to the "Securing MySQL Server" section of MySQL 5.5 to 5.7 Upgrade.docx.