MySQL database import causes issues in Alfresco 1.4 Communit

[cmathieu]

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.

However, I am able to login as Admin fine. Logged in as admin, I can't change any user's password or delete any user account. I get an "object doesn't exist" error message.

This leads me to believe that after the import of the MySQL database, Alfresco and its database seems to be out of sync. The only way to resolve this is by shutting down Alfresco, dropping the database, deleting the contents of the ALF_DATA directory and creating the database again, then all is well. The only drawback to this is that all previous data is lost.

Has anyone else encountered this previously?

I export the MySQL database using the following command run from a command prompt:

mysqldump -u root alfresco > alfrescodb.sql

and I re-import using the command:

mysql -u root alfresco < alfrescodb.sql

Is there a better way to backup the MySQL database?

Thanks

Regards,
Charles Mathieu

[deniv]

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…

[cmathieu]

Thanks Deniv,

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

Thanks heaps.

Rgds,
Charles