topic Re: MySQL database import causes issues in Alfresco 1.4 Communit in Alfresco Archive

MySQL database import causes issues in Alfresco 1.4 Communit

cmathieu — Mon, 29 Jan 2007 03:19:05 GMT

Hi All,I've just done my first MySQL database import. I am using Alfresco Community 1.40 running under Windows 2003 Server with MySQL 5.0.At first, all the data seems to have been imported correctly but when a user tries to login to Alfresco, he or she will get an "unknown user" error message.Howeve

Re: MySQL database import causes issues in Alfresco 1.4 Communit

deniv — Mon, 29 Jan 2007 06:59:18 GMT

The following procedure does work for us:
1. Shutdown Alfresco server.
2. mysqldump
3. Copy ALF_DATA into backup
As I'm aware, it is not enough to just export/import the database, the same version of ALF_DATA should be copied

PS: we've tested this scenario with a bit later SVN version, not 1.4…

Re: MySQL database import causes issues in Alfresco 1.4 Communit

cmathieu — Sun, 04 Feb 2007 22:24:19 GMT

Thanks Deniv,

Will give this a try and see if it works for me. Will let you know.

Thanks heaps.

Rgds,
Charles