Switch from PostgreSQL database to Mysql database

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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-upgrades/migrating-database