topic Re: Moving Data and Settings from 3.2r to 3.3 in Alfresco Archive

Moving Data and Settings from 3.2r to 3.3

squad — Mon, 22 Nov 2010 16:25:53 GMT

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

Re: Moving Data and Settings from 3.2r to 3.3

mrogers — Mon, 22 Nov 2010 21:18:36 GMT

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.

Re: Moving Data and Settings from 3.2r to 3.3

squad — Fri, 26 Nov 2010 13:24:07 GMT

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)

Re: Moving Data and Settings from 3.2r to 3.3

squad — Mon, 29 Nov 2010 09:19:50 GMT

Please any help?

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

Re: Moving Data and Settings from 3.2r to 3.3

squad — Tue, 30 Nov 2010 07:28:27 GMT

[size=200]PLEASE HELP[/size]

Re: Moving Data and Settings from 3.2r to 3.3

dranakan — Tue, 30 Nov 2010 08:24:24 GMT

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 ?

Re: Moving Data and Settings from 3.2r to 3.3

squad — Mon, 06 Dec 2010 13:07:18 GMT

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

Re: Moving Data and Settings from 3.2r to 3.3

squad — Fri, 10 Dec 2010 04:40:17 GMT

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

Re: Moving Data and Settings from 3.2r to 3.3

squad — Wed, 15 Dec 2010 04:05:44 GMT

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

Re: Moving Data and Settings from 3.2r to 3.3

dranakan — Wed, 15 Dec 2010 06:46:50 GMT

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.

Re: Moving Data and Settings from 3.2r to 3.3

mrogers — Wed, 15 Dec 2010 10:42:45 GMT

You haven't been posting enough detail to enable us to help you. Equally the few details you are posting are not "alfresco" problems.

Have you become familiar with backing up and restoring a test environment? Can you move alfresco from one test box to another?

At some point you had a working alfresco instance of 3.3. You did something and now the database does not seem to start.

When you say "move" the database what exactly did you do? Is the database actually running and has it got your data in it?

Re: Moving Data and Settings from 3.2r to 3.3

squad — Fri, 17 Dec 2010 14:00:01 GMT

Thank you for your attention.

I will collect all the information that you are requesting and post it here "but that's all information i can get from the logs, but i will double check it and let you know"

I hope we win this time.