Switch from PostgreSQL database to Mysql database

[aitbenmouh]

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

[mitpatoliya]

You need to stop the server
Create MySQL alfresco database with script provided with setup.
change your configuration to point to new MySQL alfresco database
http://wiki.alfresco.com/wiki/Database_Configuration

set indexing mode to full in alfresco-global.properties.

Restart the server it should reindex all your contents in new database.

but there are still few problems you will face.
Refer this post as well
http://forums.alfresco.com/forum/installation-upgrades-configuration-integration/installation-upgrad...