Postgress to MySql database migration issue.

[aditya_chaudhar]

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.??

[mrogers]

You have forgotten the important step of migrating the database!

http://stackoverflow.com/questions/5909223/migrate-database-from-postgres-to-mysql

[aditya_chaudhar]

Thanks a lot mrogers for your quick help ,

I follow link you mentioned.i convert pstgress data to mysql format. and copy all alf_data and  rebuild solr index it was working good on test level.

But as it was possible for us to have fresh installation with MySql on production we go with that.


below link helps me to install mysql with alfresco
https://sudheerreddyduganapalli.wordpress.com/2014/05/21/alfresco-community-4-2-b-installation-with-...

Thank you for your quick reply

Thanks and Regards
Aditya Chaudhari