AnsweredAssumed Answered

Change default directory for MySql?

Question asked by zanity84 on Sep 5, 2012
Latest reply on Sep 10, 2012 by amitabhandari1

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,