Change default directory for MySql?

[zanity84]

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 specifies that when restoring, both the contents of dir.root (alf_data) and the mysqldump of the alfresco database must be in the same location for it to succeed. The MySql connector can connect to the databases just fine. However, I wonder if there is a problem with the default path for the MySql databases being in a different location than the alfresco install. For instance:

MySql is stored in /var/lib/mysql
Alfresco is stored in /opt/alfresco-4.0.e

Could this be why I'm encountering problems getting my old alf_data and database restored to the newer version of Alfresco? Or is this something that the Mysql connector is supposed to handle? Thanks,

[amitabhandari1]

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,

[zanity84]

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!

[amitabhandari1]

HI ,

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

Check the upgrading topic.

Thanks,