topic Switch from PostgreSQL database to Mysql database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/switch-from-postgresql-database-to-mysql-database/m-p/288552#M241682 <HTML><HEAD></HEAD><BODY><SPAN>Hello everybody,</SPAN><BR /><BR /><SPAN>I need some help, my problem is that i setup alfresco version 4.0 in my computer, by default it install a postgreSQL database then i want to switch to Mysql database without reinstalling alfresco,because i prefer to developpe ander Mysql rather then postgreSql.</SPAN><BR /><BR /><SPAN>Thinks to help</SPAN></BODY></HTML> Tue, 12 Mar 2013 13:48:29 GMT aitbenmouh 2013-03-12T13:48:29Z Switch from PostgreSQL database to Mysql database https://connect.hyland.com/t5/alfresco-archive/switch-from-postgresql-database-to-mysql-database/m-p/288552#M241682 Hello everybody,I need some help, my problem is that i setup alfresco version 4.0 in my computer, by default it install a postgreSQL database then i want to switch to Mysql database without reinstalling alfresco,because i prefer to developpe ander Mysql rather then postgreSql.Thinks to help Tue, 12 Mar 2013 13:48:29 GMT https://connect.hyland.com/t5/alfresco-archive/switch-from-postgresql-database-to-mysql-database/m-p/288552#M241682 aitbenmouh 2013-03-12T13:48:29Z Re: Switch from PostgreSQL database to Mysql database https://connect.hyland.com/t5/alfresco-archive/switch-from-postgresql-database-to-mysql-database/m-p/288553#M241683 <HTML><HEAD></HEAD><BODY><SPAN>You need to stop the server </SPAN><BR /><SPAN>Create MySQL alfresco database with script provided with setup.</SPAN><BR /><SPAN>change your configuration to point to new MySQL alfresco database</SPAN><BR /><A href="http://wiki.alfresco.com/wiki/Database_Configuration" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Database_Configuration</A><BR /><BR /><SPAN>set indexing mode to full in alfresco-global.properties.</SPAN><BR /><BR /><SPAN>Restart the server it should reindex all your contents in new database.</SPAN><BR /><BR /><SPAN>but there are still few problems you will face.</SPAN><BR /><SPAN>Refer this post as well</SPAN><BR /><A href="http://forums.alfresco.com/forum/installation-upgrades-configuration-integration/installation-upgrades/migrating-database" rel="nofollow noopener noreferrer">http://forums.alfresco.com/forum/installation-upgrades-configuration-integration/installation-upgrades/migrating-database</A></BODY></HTML> Tue, 12 Mar 2013 14:08:34 GMT https://connect.hyland.com/t5/alfresco-archive/switch-from-postgresql-database-to-mysql-database/m-p/288553#M241683 mitpatoliya 2013-03-12T14:08:34Z