Migrating Alfresco from one machine to the other

[akshayakher]

Hi,

I have just started working with Alfresco…

I had a doubt regarding migrating data from one machine to the other…

I dont want to rework on the user database i create on my old machine..

I understand that all the data repository can be migrated my moving the alf_data folder to the new machine..but i am not very clear about the database in mysql…

I need help regarding this…

Any comments and help is appreciated..Thanks in advance…

Regards
Akshaya

[akshayakher]

in reference to the above post i would like to add that the steps in server administaration for backup and restore are easy to understand but cannot find the

dir.root property is usually located in <configRoot>/alfresco/repository.properties.

please reply back

[kevinr]

This value is generally set to:
dir.root=./alf_data
On my installation it was found here:
\apache-tomcat-5.5.16\webapps\alfresco\WEB-INF\classes\alfresco\repository.properties

Hope this helps,

Kevin

[akshayakher]

Thanks Kevin,

So what I undersatand by this is for backup and restore…

step 1: Database should be copied to alf_data folder.

step 2: The copy of this folder should be then restored to the new machine.

Does the database mean the complete mysql folder or does it mean any particular file?

Akshaya

[kevinr]

No the database should not be copied into that folder.

The "alf_data" folder contains the lucene indexes and all the content files for your Alfresco Repository. The database contains the meta-data for the files.

You need to perform a FULL export of the "alfresco" schema from your existing MySQL and then import that into your new MySQL "alfresco" schema. Then you need to copy the contents of the "alf_data" directory from your existing machine to the new one.

If you get that right, it will work ok.

Thanks,

Kevin

[akshayakher]

Thanks Kevin…that is very useful…

[akshayakher]

I tried to migrate data from my old machine to the new one

1. I installed the same version of alfresco as in my old machine.
2. Copied and overwrote the alf_data folder from old machine to the new machine.

Now nothing seems to work. I cannot login even as admin.

Can you help me as to what has gone wrong with this…

Please somebody do reply

Thanks
Akshaya