AnsweredAssumed Answered

Postgress to MySql database migration issue.

Question asked by aditya_chaudhari on Apr 1, 2015
Latest reply on Apr 9, 2015 by aditya_chaudhari
Hi Everyone ,

I have installed default alfresco on production and created site,LDAP,Kerberos and other customization.
But now i have task to migrate from postgress DB to MySql.

what i did :
1. installed MySql and change some properties in alfresco-global.properties using below link
(http://docs.alfresco.com/4.0/tasks/mysql-config.html).

2. i was getting indexing errors then i googled out a bit and found and deleted below two folders from solr

C:.Alfresco/alf_data/alf_data/solr/archive/SpacesStore
C:.Alfresco/alf_data/solr/workspace/SpacesStore

<strong>Now my logs not giving any errors , But it did not import my sites and all data from content store</strong>

My ultimate aim is to successfully migrate from postgress to MySql without any data loss.

Please let me know if you need any more information.


where i am going wrong? ?i dont have any experience in SOLR.
Please guide me , suggest me where i am going wrong.??

Outcomes