topic MySQL database import causes issues in Alfresco 1.4 Communit in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/mysql-database-import-causes-issues-in-alfresco-1-4-communit/m-p/65099#M41160 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Has anyone else encountered this previously?</SPAN><BR /><BR /><SPAN>I export the MySQL database using the following command run from a command prompt:</SPAN><BR /><BR /><SPAN>mysqldump -u root alfresco &gt; alfrescodb.sql</SPAN><BR /><BR /><SPAN>and I re-import using the command:</SPAN><BR /><BR /><SPAN>mysql -u root alfresco &lt; alfrescodb.sql</SPAN><BR /><BR /><SPAN>Is there a better way to backup the MySQL database?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Charles Mathieu</SPAN></BODY></HTML> Mon, 29 Jan 2007 03:19:05 GMT cmathieu 2007-01-29T03:19:05Z MySQL database import causes issues in Alfresco 1.4 Communit https://connect.hyland.com/t5/alfresco-archive/mysql-database-import-causes-issues-in-alfresco-1-4-communit/m-p/65099#M41160 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 Mon, 29 Jan 2007 03:19:05 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-database-import-causes-issues-in-alfresco-1-4-communit/m-p/65099#M41160 cmathieu 2007-01-29T03:19:05Z Re: MySQL database import causes issues in Alfresco 1.4 Communit https://connect.hyland.com/t5/alfresco-archive/mysql-database-import-causes-issues-in-alfresco-1-4-communit/m-p/65100#M41161 <HTML><HEAD></HEAD><BODY><SPAN>The following procedure does work for us:</SPAN><BR /><SPAN>1. Shutdown Alfresco server.</SPAN><BR /><SPAN>2. mysqldump </SPAN><BR /><SPAN>3. Copy ALF_DATA into backup</SPAN><BR /><SPAN>As I'm aware, it is not enough to just export/import the database, the same version of ALF_DATA should be copied</SPAN><BR /><BR /><SPAN>PS: we've tested this scenario with a bit later SVN version, not 1.4…</SPAN></BODY></HTML> Mon, 29 Jan 2007 06:59:18 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-database-import-causes-issues-in-alfresco-1-4-communit/m-p/65100#M41161 deniv 2007-01-29T06:59:18Z Re: MySQL database import causes issues in Alfresco 1.4 Communit https://connect.hyland.com/t5/alfresco-archive/mysql-database-import-causes-issues-in-alfresco-1-4-communit/m-p/65101#M41162 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Deniv,</SPAN><BR /><BR /><SPAN>Will give this a try and see if it works for me. Will let you know.</SPAN><BR /><BR /><SPAN>Thanks heaps.</SPAN><BR /><BR /><SPAN>Rgds,</SPAN><BR /><SPAN>Charles</SPAN></BODY></HTML> Sun, 04 Feb 2007 22:24:19 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-database-import-causes-issues-in-alfresco-1-4-communit/m-p/65101#M41162 cmathieu 2007-02-04T22:24:19Z