topic Re: Export problem in Alfresco Archive

Export problem

sparcle — Mon, 05 Sep 2011 07:53:09 GMT

Hello,I'm trying to move Alfresco CE 3.4 d from Windows to Linux machine, but without success. It was initially installed on Centos Linux and worked without problems in version 3.2. Then I had to change my linux machine so I moved it temporary to Windows. It went without any problems and works well

Re: Export problem

scouil — Thu, 08 Sep 2011 09:15:57 GMT

I migrated from windows to linux using the backup procedure and everything went well…

How are you backuping your mysql database?

Are both your alfresco in the same language (maybe different naming due to languages could crash everything)?

Re: Export problem

sparcle — Fri, 09 Sep 2011 09:53:04 GMT

Hello Scouil! Thank you very much for your reply!

I do database backup with phpMyAdmin:
1. Log-in as root
2. Choose database "alfresco"
3. And then "Export"->"Save as a file".

On the destination server I reverse the process:
1. Log-in to phpMyAdmin as root,
2. Create database "alfresco"
3. Import->"From file".

And so I have the database restored.

I have also marked one strange thing: if I try to delete all the tables from the database I got an error. While I'm logged as root I think this is not my user rights problem. Some of the tables are deleted, some resist. The error text is: "Cannot delete or update a parent row: a foreign key constraint fails". The problem occurs every time both on Windows and Linux machine. I think this is an error of 3.4d version. But this souldn't be a problem by migration, since migration from Windows to Windows goes.

Alfresco is in the same language (english) and versions (3.4.d) on both machines.

Re: Export problem

scouil — Fri, 09 Sep 2011 13:27:50 GMT

Hello,

The error you have while trying to delete is normal. It happens when you try to remove a parent table before its children tables. it can't be done because the children would point to a non-existing parent. That's normal behavior and the error doesn't come from this.

Are you doing hot backups or doing it while your server is stopped?

You may also need to check if you have your configuration (tomcat/shared/classes/extension/*) identical on both the servers (I'm especially thinking about the custom models) in order for the import to succeed.

Here is a part of the doc I wrote for my company. Forgive the windows-only paths/manipulations, I'm sure you'll be able to translate for linux.
Try this method instead of phpMyAdmin and cross your fingers:

1) Backup alfresco
   Stop alresco (go to the services panel and stop alfrescoMySql and alfrescoTomcat)
   copy your data folder (by default C:\Alfresco\alf_data)
   backup your database to a file (by default: open a prompt and write C:\Alfresco\mysql\bin\mysqldump –databases alfresco –add-drop-database > dumpAlf.sql -u root -p )
   keep both the copy of alf_data and the generated dumpAlf.sql. those are the file you need to be able to restore alfresco.
   restart alfresco (go to the services panel and start alfrescoMySql and alfrescoTomcat)

2) Restore alfresco
   Stop alresco (go to the services panel and stop alfrescoMySql and alfrescoTomcat)
   replace your data folder (by default C:\Alfresco\alf_data) with the one previously backed up
   restaure your database from the file previously backed up (C:\Alfresco\mysql\bin\mysql < dumpAlf.sql -u root -p)
   restart alfresco (go to the services panel and start alfrescoMySql and alfrescoTomcat)

Hope this works.

Re: Export problem

sparcle — Tue, 20 Sep 2011 19:20:30 GMT

Thank You for all of your information!
Unfortunately - this did not help. I have changed the Linux machine meantime (I hoped that this may be because of too week server and after switching to 64 bit it will start to work…) - but the problem still remains. There is no problem when I do exactly what you have told me by moving to another Windows machine. But when I try move to Linux - it fails every time.

Anyway - I have a brand new instance of Alfresco CE 3.4d running on Linux. There is no problem to set up the users - there are only few of us. What's important - this is the pages in Share that we just can't loose…