Upgrade to 3.3: DB Problem

[sb1017]

Hi everyone,
this is my first upgrade since 3.2 and I don't understand the following step in the "Generell Upgrade Process":
Step 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 says: "Restore the database from the database backups. "
what does this mean? The Alfresco 3.2 DB has 78 tables and 3.3 has 88 tables so when I dumped the 3.2 DB and used it with 3.3 there have been several errors during the "boot"-process (tables missing…). Further I tried to copy (with inserts) the content of the 3.2 DB into the 3.3 DB with phpmyadmin and mysqldumper. This neither was successful. 😞

So how is the write way to "restore the database from the database backups" in order to get v3.3 running?

Thanks for your help
Sebastian

[sb1017]

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

[loftux]

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

[sb1017]

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

[loftux]

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.

[sb1017]

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…