Upgrading Alfresco CE version

[redbull]

this page:
http://docs.alfresco.com/5.0/concepts/upgrade-path.html
describes the general upgrade paths, so I understand that from 3.x to 5.x it's necessary go towards 4.x before.
For the database, the path suppose "Backing up and restoring the repository";
now, my 3.x database is MYSQL.
How I can use the mysql backup to restore in postgres 4.x database?

Thanks!

[mitpatoliya]

You can configure your new alfresco instance(with upgraded version) to use MySQL and then point to same db. You may run in to issues if you try to migrate from MySQL to PostSQL which is unnecessary if you just want to upgrade alfresco.

[redbull]

Thank you mitpatoliya for the suggest,
I have a doubt: the MySQL 3.x database is perfectly compatible with Alfresco 4.x or this (new alfresco instance) introduces changes to the structure of the tables?

[mrogers]

Yes there will be differences but alfresco will deal with it in the upgrade process.

[redbull]

so, following your tips I did a test.
The starting point was to have 3.4.d working version. Then:
1) install Alfresco CE 4.2.f
2) start Alfresco CE 4.2.f to verify that it works; …and stop Alfresco: all is OK
3) modify 4.2.f alfresco-global.properties:
   A) configure MySQL database instead of POSTGRES:
      ### POSTGRES database connection properties ###
      ### db.driver=org.postgresql.Driver
      ### db.username=alfresco
      ### db.password=alfresco
      ### db.name=alfresco
      ### db.url=jdbcostgresql://localhost:7432/${db.name}
      ### MYSQL database connection properties
      ### NOTE: this is the same MYSQL istance used by Alf 3.4.d
      db.driver=org.gjt.mm.mysql.Driver
      db.username=alfresco
      db.password=alfresco
      db.name=alfresco
      db.url=jdbc:mysql://localhost:3366/${db.name}?useUnicode=yes&characterEncoding=UTF-8
      Copy the JAR file mysql-connector-java-5.1.13-bin.jar into the <TOMCAT_HOME>/lib directory for Tomcat (C:\Alfresco_4.2.f\tomcat\lib)
   B) configure dir.root:
      ### dir.root=C:/ALFRES~1.F/alf_data
      NOTE: this is the same dir.root used by Alf 3.4.d
      dir.root=C:/Alfresco_3.4.d/alf_data
   C) replace SOLR with LUCENE:
      ### Solr indexing ###
      ### index.subsystem.name=solr
      ### dir.keystore=${dir.root}/keystore
      ### solr.port.ssl=8543
      ### Lucene indexing ###
      index.subsystem.name=lucene

Start mysql and alfresco 4.2.f tomcat services: they start.
With Alfresco Explorer I did a check: see ALL the 3.4.d repo (user, space, ACL,…) but checking a space content I don't see any documents!!!
In what I did wrong?

[mrogers]

Are you accessing the correct database?       Do you have an instance of mysql that is separate from alfresco or one that is bundled inside?

[redbull]

I use bundled inside MYSQL instance, the one that comes with ALF 3.4.d version.

[redbull]

I redid the test, following the same steps described above and magically all work correctly!
Now I can see the documents!
I don't know if this is the correct procedure to upgrade 3.x to 4.x version, anyway I can say it works.
Thanks to mitpatoliya and mrogers for the support.