...
| DB Objects | Upgradation Issues | |
| Tables | 5(trigger related tables) | Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER., |
| Views | No Issues | |
| Procedures | All Procedures | Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER., Reserved keywords whould be changed toMysql supported columns. ex: system,value etc.(identified in Pr_Practioner sp) |
| Triggers | All Triggers | Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER., |
| Functions | No Issues | |
| Events | All Events | /*!50003 SET @saved_sql_mode = @@sql_mode */ ;; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; |
After successfully restored schema need to execute all db access query in production/localmmu.
- Database Restoration:
- Duration: 2 hours
- Description: Restored the database from the backup created earlier.
- Creation of Database Users:
- Description: Created necessary database users with required privileges for operational needs.
- Configuration of WildFly:
- Description: Set up WildFly paths for Java and MySQL to ensure proper integration and functionality.
- Creation of Shortcuts:
- Description: Created necessary shortcuts on the desktop for quick access to the newly installed tools.
...
sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
OpenKM Addition we have to do in below folder-
E:\uat_new\tomcat\bin\setenv.bat
Edit/open and past set "JAVA_HOME=C:\Program Files\Java\jdk1.8.0_202"