I. Steps to upgrade MySQL 5.5 to MySQL 5.7 
==========================================


 SapphireIMS Server and MySQL Server both on same machine
 --------------------------------------------------------
  
    1. Unzip the MySQLUpgrade_V2.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
       <MySQLUpgrade_V2.0 folder path>\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_V2.0 folder path>\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_V2.0.zip file.
		   
    2. Download mysql-installer-community-5.7.17.0.msi from the following link and copy to 
       <MySQLUpgrade_V2.0 folder path>\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_V2.0 folder path>\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_V2.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
       <MySQLUpgrade_V2.0 folder path>\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_V2.0 folder path>\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.  <SapphireIMS installed path>\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.  <SapphireIMS installed path>\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.
         <SapphireIMS Installed path>\ConsoleManagement\ExternalWar\SoftwareRepository.war\MySQLUpgrade\Logs\
         
    ii.  Database backup files can be found in the following folder.
         <SapphireIMS Installed path>\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.