topic More than one Alfresco schema- on export/restore DB in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/more-than-one-alfresco-schema-on-export-restore-db/m-p/60327#M21205 <HTML><HEAD></HEAD><BODY><P>I am&nbsp;moving alfresco database from Oracle to MySQL AWS, Performed export and import of database and content store using cold backup procedure.</P><P>I am getting the below error message when trying to start application server- we have set schema update to false in global properties file.</P><P></P><P><SPAN style="color: #3d3c40; background-color: rgba(61, 60, 64, 0.08);">More than one Alfresco schema was found when querying the database metadata. Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.</SPAN></P><P></P><P><SPAN style="color: #3d3c40; background-color: rgba(61, 60, 64, 0.08);">There is something wrong or need to be changed at database side which I think easy to fix if&nbsp;you have good knowledge of MySQL.&nbsp;</SPAN></P><P><SPAN style="color: #3d3c40; background-color: rgba(61, 60, 64, 0.08);">why alfresco thinks that there are more than on&nbsp;<SPAN>Alfresco&nbsp;schema when my database contains only one schema.</SPAN></SPAN></P><P></P><P><SPAN style="color: #3d3c40; background-color: rgba(61, 60, 64, 0.08);">-D</SPAN></P><P></P><P></P></BODY></HTML> Wed, 19 Dec 2018 08:32:31 GMT dharmendra_pan3 2018-12-19T08:32:31Z More than one Alfresco schema- on export/restore DB https://connect.hyland.com/t5/alfresco-forum/more-than-one-alfresco-schema-on-export-restore-db/m-p/60327#M21205 I am&nbsp;moving alfresco database from Oracle to MySQL AWS, Performed export and import of database and content store using cold backup procedure.I am getting the below error message when trying to start application server- we have set schema update to false in global properties file.More than one Alfre Wed, 19 Dec 2018 08:32:31 GMT https://connect.hyland.com/t5/alfresco-forum/more-than-one-alfresco-schema-on-export-restore-db/m-p/60327#M21205 dharmendra_pan3 2018-12-19T08:32:31Z Re: More than one Alfresco schema- on export/restore DB https://connect.hyland.com/t5/alfresco-forum/more-than-one-alfresco-schema-on-export-restore-db/m-p/60328#M21206 <HTML><HEAD></HEAD><BODY><P>Solution : In mySQL schema and tables name were in uppar case so it was showing error message&nbsp;<SPAN style="color: #3d3c40; background-color: rgba(61, 60, 64, 0.08);">More than one Alfresco schema was found.</SPAN></P><P>Alfresco started perfectly fine when I converted schema/database and tables name to lower case.</P><P></P><P>-D</P></BODY></HTML> Mon, 14 Jan 2019 12:40:03 GMT https://connect.hyland.com/t5/alfresco-forum/more-than-one-alfresco-schema-on-export-restore-db/m-p/60328#M21206 dharmendra_pan3 2019-01-14T12:40:03Z