Using an Existing MySQL database

[rameshj03]

Hi All,

I downloaded and installed a free version of Alfresco 4.1 Also I have replaced PostgreSQL to MySQL 5.6 database (separate repository). I have configured for LDAP Auth and Sync. It is working fine.

However when I re-installed the same Alfresco version and tried to connect with the same existing repository (I want to use all the data in existing MySQL database), I am getting the error message "CONTENT INTEGRITY ERROR: System content not found in content store."

Is it possible to just direct to existing MySQL database by configuring path values in alfresco-global properties file? Or I should do back up all content related data and create a new empty database and restore old content whenever I re-install/install a new version?

Thanks and Regards,
Ramesh.

[sujaypillai]

When you say existing repository - <strong> its not only the database</strong>. You should also point your dir.root=

<path to old location>‍

OR copy the old contents to a new location and then point dir.root to this.

Please refer this wiki page : http://wiki.alfresco.com/wiki/Backup_and_Restore

[rameshj03]

Hi Sujaypillai,

Thanks for the reply. I missed the backup step mentioned in the link. It works fine now.

-Ramesh.

[rameshj03]

Hi volkeram,

Thanks for the information. I got it working fine.

-Ramesh.

[volkeram]

If you are transporting all your data fro PHPBB then having them in the same database is no trouble at all. I didn't have to have them in the same database.