topic Re: Change default directory for MySql? in Alfresco Archive

Change default directory for MySql?

zanity84 — Wed, 05 Sep 2012 18:00:02 GMT

Hello,I noticed that when trying to restore a MySql database and alf_data from a previous version (3.4.d) to the newest Alfresco version, 4.0.e, I am getting numerous schema-validation problems. I have the MySql connector in tomcat/lib, but I wondered something:The backup/restore procedure blatantly

Re: Change default directory for MySql?

amitabhandari1 — Thu, 06 Sep 2012 07:34:18 GMT

Hi,

There should not be any problem of changing the directory location. Are you doing upgrade and is this happening while upgrade is in progress.
Are you also facing similar kind of validation errors:

012-08-22 05:31:28,347 WARN [domain.schema.SchemaBootstrap] [main] Schema validation found 81 potential problems, results written to: /opt/alfresco402/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Pre-Upgrade-alf_-8177759383561323090.txt
2012-08-22 05:31:28,425 WARN [domain.schema.SchemaBootstrap] [main] Schema validation found 14 potential problems, results written to: /opt/alfresco402/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Pre-Upgrade-avm_-3052080491422848160.txt
2012-08-22 05:31:28,453 WARN [domain.schema.SchemaBootstrap] [main] Schema validation found 28 potential problems, results written to: /opt/alfresco402/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Pre-Upgrade-jbpm_-7762514199473028451.txt

Thanks,

Re: Change default directory for MySql?

zanity84 — Thu, 06 Sep 2012 15:11:20 GMT

Hi there,

I am getting those very types of errors, or I guess warnings. I am in the process of testing 4.0.e with our current system 3.4.d. I want to see if I could get it running with both the same contentstore and database from 3.4 on the newest version. So far, I must be missing something! I am able to successfully install 4.0.e with a clean database and dir.root, so I know that the connector is working. Only when I try and restore my dir.root and database from 3.4 do I run into this problem. The alfresco.log has a ton of those warnings, and I end up not even being able to log into Alfresco.

With regard to the default path, is it necessary to move it? I only wonder this because of the specification in Backup/Restore to keep both alf_data and the database together. Thanks for your help!

Re: Change default directory for MySql?

amitabhandari1 — Mon, 10 Sep 2012 11:05:22 GMT

HI ,

Please refer the following link http://docs.alfresco.com/4.0/index.jsp .

Check the upgrading topic.

Thanks,