Moving Data and Settings from 3.2r to 3.3

[squad]

Hi All,

i would like to now if its possible to move the data and settings (i mean spaces and documents) from alfresco 3.2r to 3.3.
The point is that my alfresco 3.2r (on windows XP) is not loading because it can connect to MySql DB (i have tried to fix it but i couldn't), and as this is a very useful solution for my client and a lot of people are using it. i decide to install  the version 3.3 on Ubuntu 10.04. Server
Witch is working smoothly. so i would like to move the data and the configuration from the old (not working) 3.2r to the new 3.3.

Please advise

[mrogers]

This is the wiki page you need to use.

http://wiki.alfresco.com/wiki/Backup_and_Restore

You will need to dump and import the database contents into your new database and copy in the content store (the files below alf-data).
Then when you start alfresco it will update the data.

[squad]

This is the wiki page you need to use.

http://wiki.alfresco.com/wiki/Backup_and_Restore

You will need to dump and import the database contents into your new database and copy in the content store (the files below alf-data).
Then when you start alfresco it will update the data.

Hi mrogers, i did what's on the wiki and i findout that i have the same logs that i have on a Windows Instalation, so im posting it here.

Catalina.log
Nov 26, 2010 7:10:17 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Nov 26, 2010 7:10:17 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3139 ms
Nov 26, 2010 7:10:18 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Nov 26, 2010 7:10:18 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Nov 26, 2010 7:10:34 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
Nov 26, 2010 7:13:08 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Nov 26, 2010 7:13:08 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
Nov 26, 2010 7:13:32 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive mobile.war
Nov 26, 2010 7:13:50 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
Nov 26, 2010 7:14:19 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Nov 26, 2010 7:14:19 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 241533 ms


MySQL logo

101125 12:31:39 [Note] /usr/sbin/mysqld: Normal shutdown

101125 12:31:39 [Note] Event Scheduler: Purging the queue. 0 events
101125 14:54:19 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Log scan progressed past the checkpoint lsn 0 6483128
101125 14:54:20  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
InnoDB: Doing recovery: scanned up to log sequence number 0 6483863
101125 14:52:08  InnoDB: Starting an apply batch of log records to the database…
InnoDB: Progress in percents: 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
101125 14:52:09  InnoDB: Started; log sequence number 0 6483863
101125 14:52:09 [Note] Event Scheduler: Loaded 0 events
101125 14:52:09 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.7'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
101125 14:54:20 [Note] /usr/sbin/mysqld: Normal shutdown

101125 14:54:20 [Note] Event Scheduler: Purging the queue. 0 events
101125 14:54:20  InnoDB: Starting shutdown…
101125 14:54:23  InnoDB: Shutdown completed; log sequence number 0 6483863
101125 14:54:23 [Note] /usr/sbin/mysqld: Shutdown complete

101126  2:35:18 [Note] Plugin 'FEDERATED' is disabled.
101126  2:35:21  InnoDB: Started; log sequence number 0 6483863
101126  2:35:22 [Note] Event Scheduler: Loaded 0 events
101126  2:35:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.7'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
101126  6:12:36 [Note] Plugin 'FEDERATED' is disabled.
101126  6:12:38  InnoDB: Started; log sequence number 0 6483863
101126  6:12:38 [Note] Event Scheduler: Loaded 0 events
101126  6:12:38 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.7'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
101126  6:21:25 [Note] /usr/sbin/mysqld: Normal shutdown

101126  6:21:25 [Note] Event Scheduler: Purging the queue. 0 events
101126  6:21:25  InnoDB: Starting shutdown…
101126  6:21:28  InnoDB: Shutdown completed; log sequence number 0 6483863
101126  6:21:28 [Note] /usr/sbin/mysqld: Shutdown complete

101126  6:26:16 [Note] Plugin 'FEDERATED' is disabled.
101126  6:26:18  InnoDB: Started; log sequence number 0 6483863
101126  6:26:18 [Note] Event Scheduler: Loaded 0 events
101126  6:26:18 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.7'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
101126  7:08:38 [Note] /usr/sbin/mysqld: Normal shutdown

101126  7:08:38 [Note] Event Scheduler: Purging the queue. 0 events
101126  7:08:38  InnoDB: Starting shutdown…
101126  7:08:40  InnoDB: Shutdown completed; log sequence number 0 6483873
101126  7:08:40 [Note] /usr/sbin/mysqld: Shutdown complete

101126  7:11:48 [Note] Plugin 'FEDERATED' is disabled.
101126  7:11:50  InnoDB: Started; log sequence number 0 6483873
101126  7:11:50 [Note] Event Scheduler: Loaded 0 events
101126  7:11:50 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.7'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

[squad]

Please any help?

i really need to make it work, we are on the 4th week without Alfresco, please guys say something.

[squad]

[size=200]PLEASE HELP[/size]

[dranakan]

Hello,

In which version was Alfresco working ? (you say it was in 32R2 but not working). Or there was a problem with the Mysql ? If yes… what's happened with it ?

Before doing the update, have you tried to start the server 3.3 (without your data) ? Working ?

[squad]

Hello dranakan,

I was using the version 3.2r on XP it doesn't startup, so i decided to move to linux, and installed it on Ubuntu server 10.04. the system is running fine without the data from 3.2r.
when i move the alf_data and the mysql data base it gives the errors that i posted here, that is the same that is happening on the XP machine.

i dont think its a mysql problem because when i try to launch Alfresco i receive a message that says "mysqld: ready for connections.".
and the catalina shows the same information that i posted on catalina.log

[squad]

Is There Any WAY to recover the DATA, i have very important DATA on the system, and i would like to have it back. as it seems to be a very big issue.
Please advice on the best way to recover the information on this situation.

Best regards

[squad]

ANY ONE TO HELP ME RECOVER MY INFORMATION.

IM ABOUT TO LOOSE MY JOB, BECAUSE I WAS THE ONE WHO SUGGESTED TO USE ALFRESCO NOW ITS NOTWOTKING FOR MORE THEN A MONTH, AND MY BOSSES ARE NOT TAKING ME SERIOS.

AS THERE'S IMPORTANT DATA. PLEASE LET ME KNOW HOW TO RECOVER IT EVEN I HAVE TO PAY I WILL DO.

THANKS IN ADVANCE

[dranakan]

Hello,

Your Alfresco log does not be complete….
Can you start Alfresco and post others logs (normally it's catalina.out), perhaps look for others logs files.