topic Migrating from 1.4 community to 2.0 using bootstrap import in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/migrating-from-1-4-community-to-2-0-using-bootstrap-import/m-p/47429#M26895 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>First post here, sorry if it's a little lengthy, but I wanted to give some background, also this may be helpful to noobs…&nbsp; </SPAN><BR /><BR /><SPAN>I've been evaluating 1.4 for a few months now and I wanted to get a clean start and migrate my data over to 2.0 community. In the process I wanted to optimize my system a little, so I started from scratch with building the server.</SPAN><BR /><BR /><SPAN>I'm running VMware on CentOS, which is just spectacular for testing and building servers, but that's another topic.&nbsp; So, because CentOS is based on RHEL, which is nearly the enterprise standard linux, I chose it as my base OS for Alfresco.&nbsp; Installed CentOS 4.4 server (from the single, minimal server ISO).&nbsp; A side note on this, I thought it'd be nice for my Alfresco VM to have a separate disk mounted at /opt/alfresco for the data, so if I need to expand the ISO later, it would be a little easier.&nbsp; For alfresco installer, you need X11 of some form, but the CentOS Gnome/KDE installers don't install a functioning environment (guess not too many people install CentOS with the GUI), so I installed with the "minimal" option then ran "# yum groupinstall "GNOME Desktop Environment"" and upon completion issued "# xinit /usr/bin/gnome-session".&nbsp; This installs a working Gnome environment, which is then capable of running the Alfresco 2.0 installer.&nbsp; Before running the Alfresco installer, I ran "# yum update" to get all the CentOS patches.</SPAN><BR /><BR /><SPAN>Ok, so I've got a clean minimal CentOS with a separate 20GB partition mounted at /opt/alfresco (just testing things here, so why waste the space), a functioning GUI and up-to-date patches.</SPAN><BR /><BR /><SPAN>Now to get a decent DB backend, I grab the MySQL5 RHEL4 RPM packages for the server, client and dependencies.&nbsp; All is well with MySQL.</SPAN><BR /><BR /><SPAN>Install Alfresco2 with selecting MySQL (oddly it still puts a bunch of HSQL stuff in the filesystem).&nbsp; Remove the HSQL files, run db_setup.bat, take a snapshot of my VMware machine, then "/opt/alfresco/alf_start.sh".&nbsp; everything comes up fine.</SPAN><BR /><BR /><SPAN>Ok, now I revert back to my snapshot, so I have an un-populated MySQL db and an empty repository.&nbsp; I go to my Alf1.4 server and do an Export of the complete repository, including children.&nbsp; I take the 6 files, move them into the /alfresco/extension/restore folder, change them to lowercase export_spaces.acp, export_users.acp etc (looking at the restore-context.xml file, it calls them in lowercase, so just to be safe). then on all the files i chown root, chgrp root, chmod 755.&nbsp; i then run "# cp restore-context.xml.sample restore-context.xml".</SPAN><BR /><BR /><SPAN>Ok, at this point it looks like everything is good to go.&nbsp; I "# /opt/alfresco/alf_start.sh" and wait about 15 minutes for the java process to churn.&nbsp; when the churning is done, </SPAN><A href="http://localhost:8080/alfresco" rel="nofollow noopener noreferrer">http://localhost:8080/alfresco</A><SPAN> returns a broken tomcat error page.</SPAN><BR /><BR /><SPAN>I tried this several ways, dropped the MySQL tables deleted alf_data and re-tried editing the restore-context.xml to only pull in the users (which is mostly what I'm trying to suck out of the 1.4), etc etc etc.&nbsp; After about a dozen attempts anytime I try to bootstrap any data from 1.4 it kills the server.</SPAN><BR /><BR /><SPAN>Any advice would be much appreciated. </SPAN><BR /><BR /><SPAN>Also, if anybody has any questions about my CentOS or VMware setup, I am in the process of blogging the whole procedure with great detail, so I can post a link when done.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>-jb</SPAN></BODY></HTML> Fri, 09 Mar 2007 16:46:39 GMT jeromebrock 2007-03-09T16:46:39Z Migrating from 1.4 community to 2.0 using bootstrap import https://connect.hyland.com/t5/alfresco-archive/migrating-from-1-4-community-to-2-0-using-bootstrap-import/m-p/47429#M26895 Hi All,First post here, sorry if it's a little lengthy, but I wanted to give some background, also this may be helpful to noobs…&nbsp; I've been evaluating 1.4 for a few months now and I wanted to get a clean start and migrate my data over to 2.0 community. In the process I wanted to optimize my system a Fri, 09 Mar 2007 16:46:39 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-1-4-community-to-2-0-using-bootstrap-import/m-p/47429#M26895 jeromebrock 2007-03-09T16:46:39Z Re: Migrating from 1.4 community to 2.0 using bootstrap import https://connect.hyland.com/t5/alfresco-archive/migrating-from-1-4-community-to-2-0-using-bootstrap-import/m-p/47430#M26896 <HTML><HEAD></HEAD><BODY><SPAN>Ok</SPAN><BR /><BR /><SPAN>Now, I'm just looking for any way to migrate from 1.4 –&gt; 2.0</SPAN><BR /><BR /><SPAN>I've been trying to do this for about 12 hours straight so my eyes are kinda going blurry.</SPAN><BR /><BR /><SPAN>Can't figure how to dump or extract anything from hsql. Bootstrap import fails, importing any repository files don't retain versions or history, which makes them useless.</SPAN><BR /><BR /><SPAN>The thing that sort of stinks is that I have 7 users testing the system with 4 total files within a single folder, so the data i'm trying to migrate is minimal, but it's almost totally impossible to go from 1.4/hsql to 2.0/mysql.</SPAN><BR /><BR /><SPAN>It seems like I can't be the only one who is trying this…</SPAN><BR /><BR /><SPAN>I'll personally fedex anyone a beer who can figure this out.</SPAN><BR /><BR /><SPAN>-jb</SPAN></BODY></HTML> Fri, 09 Mar 2007 21:54:24 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-1-4-community-to-2-0-using-bootstrap-import/m-p/47430#M26896 jeromebrock 2007-03-09T21:54:24Z