topic New Alfresco version old mysql Schema in Alfresco Archive

New Alfresco version old mysql Schema

fbehfar — Mon, 01 Jun 2009 13:07:20 GMT

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

Re: New Alfresco version old mysql Schema

fbehfar — Sat, 06 Jun 2009 09:31:56 GMT

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

Re: New Alfresco version old mysql Schema

mrogers — Sat, 06 Jun 2009 11:58:20 GMT

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

Re: New Alfresco version old mysql Schema

fbehfar — Sat, 06 Jun 2009 12:47:10 GMT

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

Re: New Alfresco version old mysql Schema

mrogers — Sat, 06 Jun 2009 14:19:04 GMT

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.

Re: New Alfresco version old mysql Schema

fbehfar — Sun, 07 Jun 2009 17:05:22 GMT

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

Re: New Alfresco version old mysql Schema

fbehfar — Sat, 13 Jun 2009 05:43:33 GMT

Hi everyone,
does anyone have an idea?????
plz help me

thanks
FSB