cancel
Showing results for 
Search instead for 
Did you mean: 

New Alfresco version old mysql Schema

fbehfar
Champ on-the-rise
Champ on-the-rise
Hi,
I have changed my Alfresco version from AlfrescoCommunity-2.9.0dev to Alfresco-Labs-3Stable .
I have backup my alf_data folder and also my mysql schema. then I installed the new version and I created a new schema in mysql and restore the backup into the new schema, that I have created in alfresco configuration, and copy the alf_data into the new alfresco version. BUT I got error!
my question is, how can I use the new version with the same old schema! where is this configuration file, in which I can change the schema name to the old one!
any other suggestion with this case would be appriciated!

thank you in advanced,



FSB
6 REPLIES 6

fbehfar
Champ on-the-rise
Champ on-the-rise
Hi,
Any idea?????
I need one alfresco to switch between 2 schema! how can I handle it? where can I find the schema configuration????

thanks

FSB

mrogers
Star Contributor
Star Contributor
Alfresco manages the data migration between versions, you don't fiddle with database schemas yourself.    And if you are tempted to do manual administration you also need to worry about data migration issues as well as schema changes.

If something goes wrong as in your first posting then you need to give exact details, what you tried and what errors occurred.

If your question is how to change database settings then your repository.properties file is the place to look.

http://wiki.alfresco.com/wiki/General_Upgrade_Process

fbehfar
Champ on-the-rise
Champ on-the-rise
Hi,
The scenario is:
I have installed the Lab3, and my company had worked on it, but I didn't work with share, when I wanted to work that, I notified that the share doesn't work!!! so I decided to install it again in another folder to keep the previous version working! the previous one didn't have virtual server. when I installed the new one, I restored the schema to the new created schema, and copy alf_data folder too, when I start the server, the tomcat doesn't come up!!!! I don't know what's wrong with it???? a strange thing is, the restored schema doesn't have the same capacity!?!?!?!?

would you please help me?

FSB

mrogers
Star Contributor
Star Contributor
So do you still have a working instance of Alfresco?   Or are both instances damaged now?

It is possible to run multiple instance of alfresco on one machine but it needs careful configuration to ensure that the resources are kept separate from each other.      It will be much easier for you to set up another server for your experiments.   Or to only run one server at a time.
As well as the database and alf data folder there will also be the network settings and the property files which will need to be configured.  

The first clash you will find is tomcat's http port (8080)  which will stop the second instance of tomcat starting but after that there will be loads more clashes.

fbehfar
Champ on-the-rise
Champ on-the-rise
Hi,
Actually I don't run two Alfrescos together.
the thing I need is to migrate from the old installed one to the new one, both of them have the same version, but I guess the old one have installed with some problems because the alfresco share doesn't work!i notified it after a while, after I wanted to work with share! I have deployed some workflows and my company has uploaded many files!
to solve this problem I have decided to install alfresco again in another folder! by installing the new one, i was asked to give a name for creating a new schema in database, i thought by giving the old name it connect to the previous created schema, so I won't have a problem in data lost. but it said 'it already exist' so I had to give another name to create a new schema. after that I backup from my previous mysql schema and restore it into the newly created schema, and also copy the alf-data from old one to new one, but tomecats didn't come up!!!
all I need, is to work with the newly installed alfresco without losting any data! i don't want to use both alfrescos, I just want to work with the correct one!
I have done all the backup steps in alfresco documents, but it didn't work.

would you please help me,
thanks in advanced

FSB

fbehfar
Champ on-the-rise
Champ on-the-rise
Hi everyone,
does anyone have an idea?????
plz help me Smiley Sad


thanks
FSB