topic Re: Upgrade to 3.3: DB Problem in Alfresco Archive

Upgrade to 3.3: DB Problem

sb1017 — Thu, 29 Apr 2010 10:47:51 GMT

Hi everyone,this is my first upgrade since 3.2 and I don't understand the following step in the "Generell Upgrade Process"tep 6 of Generall Restore Process saya:"Restore the backup taken in step 2 into the new repository (not the existing one), as described at Restore procedure. "Restore step 5 sa

Re: Upgrade to 3.3: DB Problem

sb1017 — Fri, 30 Apr 2010 09:25:37 GMT

Please help me… Most people in here have run an upgrade, isn't it? So what do I do with the database? Dump, copy content, …? How do I do it on a Windows Sserver?

Thanks a lot
Sebastian

Re: Upgrade to 3.3: DB Problem

loftux — Fri, 30 Apr 2010 10:50:09 GMT

Start, run, cmd
then
c mysql –u root -p < c:\path\to\dump\myalfdb.sql

Re: Upgrade to 3.3: DB Problem

sb1017 — Fri, 30 Apr 2010 12:28:21 GMT

Hi,
thanks for your answer, but this is only to dumb an existing DB. My problem is the restore of my v3.2 Repository to v3.3. When I use the v3.2 DB for v3.3 I got several errors about missing tables, when starting alfresco…

Regards
Sebastian

Re: Upgrade to 3.3: DB Problem

loftux — Fri, 30 Apr 2010 13:48:20 GMT

I'm not sure then what you have done. What I posted was how to restore your dump.
First you dump your db, then restore to test server. It will be a 3.2 restore
Copy your alf_data to a new location where you have your 3.3 install.
Make sure alfresco-global.properties point to correct db and alf_data.
Start your 3.3 install. It should take care of all your db conversion, there is no need to fiddle with tables yourself. If all goes well, you are on 3.3
(the above is a very short version of the upgrade advise found in the wiki about upgrade).

So what errors do you have? If it complains about missing tables when you start your 3.3 install, then your dump/restore probably wasn't correct.

Can't help you any more than that without you posting a log file.

Re: Upgrade to 3.3: DB Problem

sb1017 — Fri, 30 Apr 2010 14:16:49 GMT

Yeah man. This time it worked. Sorry I couldn't give more details about the error, because from my point of view I only was trying again, what I did before. Anyway:

1) Backup your 3.2 DB
2) Install v3.3 to an empty directory
3) copy v3.2 alf_data into it (rename v3.3 alf_data)
4) start alfresco 3.3

That's it… 🙂

Thanks for your help!
Sebastian

PS: My first impression is, that it's not so performant like before… but we'll see…