topic Re: Alfresco community 4.2.c - issues using MySQL 5.6.10.1 database in Alfresco Archive

Alfresco community 4.2.c - issues using MySQL 5.6.10.1 database

scott_dalzell — Tue, 05 Mar 2013 11:09:33 GMT

I am new to alfresco and I have been scouring these forums for the last few weeks looking for a solution for this problem so any help would be greatly appreciatedI am trying to install alfresco community 4.2.c on Windows 7 and have it connect to an existing standalone MySQL 5.6 database (i.e. not a

Re: Alfresco community 4.2.c - issues using MySQL 5.6.10.1 database

dranakan — Tue, 05 Mar 2013 12:39:00 GMT

Hello,

You need to restore the database with your backup dump.

Sample (to run in a console) :

mysql -ualfresco -pPASSWORD alfresco < D:\backup_dump\Export_data_base_Alfresco.sql‍

http://wiki.alfresco.com/wiki/Backup_and_Restore#Restore_Procedure

Before the point 11, try to run Alfresco to check your installation. After that, you can continue with the restore.

Re: Alfresco community 4.2.c - issues using MySQL 5.6.10.1 database

scott_dalzell — Wed, 06 Mar 2013 11:33:00 GMT

That worked a storm.

i had restored the sql database before but it was always after the i had restored the contents into the alf_data (dont know if that would have effected it).

i also updated the properties file to include lucene indexs

thank you again

Re: Alfresco community 4.2.c - issues using MySQL 5.6.10.1 database

scott_dalzell — Wed, 06 Mar 2013 11:37:11 GMT

My final Procedure that worked was as follows

1/ Install MySSQL using mysql-installer-community-5.6.10.1.msi
        >   Full install

2/ Add environment Variables
        > Path (C:\Program files\mySQL\MySqlServer 5.6\Bin)

3/ Open Cmd.exe and log into MySQL
        > Mysql –u root –p

4/ Create Alfresco database
        >   Create database alfresco;

5/ Create user
        >Create user ‘alfresco’@’localhost’ identified by ‘alfresco’

6/ Grant permissions
        > Grant all privileges on *.* to ‘alfresco’@’localhost’
        > With grant option;

7/ Install Alfresco community 4.2.c (install Settings below)
        > Install all components except the Postgresql
        > Folder – C:\alfresco

Database Config
        > URL      - jdbc:mysql://localhost:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8
        > JDBC Driver   - org.gjt.mm.mysql.Driver
        > DB name    - alfresco
        > DB user   - alfresco
        > Password   - *******

8/ Updating properties
        > open C:\Alfresco40a\tomcat\shared\classes\ alfresco-global.properties.sample
        > check Dir.root=c:\alfresco\alf_data
        > uncomment url and Driver sections (updating to suit)
        > uncomment db username and password (updating to suit)
        > Insert index type index.subsystem.name=lucene (if using lucene indexs)

9/ Rename alfresco-global.properties.sample to alfresco-global.properties
        > alfresco-global.properties.sample to alfresco-global.properties

10/ Apply MySQL Connector
        > Copy Connector J 5.1.23.Jar to [Dir.root]\tomcat\lib

11/ restore mysql database in CMD
        > mysql –u alfresco –p PASSWORD alfresco <D:\backup_dump\Export_data_base_Alfresco.sql

12/ restore contents, contents.delete and lucene indexes to alf_data folder

13/ Add full recovery to global properties

14/ start alfresco service

15/ run alfresco