Alfresco 4.2c + MySQL

[brgsousa]

Hi,
how can I install mysql instead of postgres during the wizard installer? Since the connector does come built-in with the installer, it can't initialize the database along with it.

I am using this linux installer:
http://wiki.alfresco.com/wiki/Download_and_Install_Alfresco
and Debian Squeeze 64 bit

Even if I configure it correctly, it doesn't work because the connector isn't in the libraries folder during installation:

Database Configuration
JDBC URL: [jdbc:postgresql://localhost/alfresco]: jdbc:mysql://10.43.4.105:3306/database?useUnicode=yes&characterEncoding=UTF-8
JDBC Driver: [org.postgresql.Driver]: org.gjt.mm.mysql.Driver
‍‍‍‍‍

[bisana]

Hi
(1)Please download "mysql-connector-java-*.jar" (take the latest) from 'http://dev.mysql.com/downloads/connector/j/'.
Then place it in /tomcat/lib directory
(2) in alfresco-global.properties cross check ur DB details, it should be like

db.driver=org.gjt.mm.mysql.Driver
db.username=givedbusername
db.password=givedbuserpassword
db.name=givedbname
db.url=jdbc:mysql://localhost/givedbname
‍‍‍‍‍‍‍

(3) Make sure in ur DB u have the above defined DB and user with the password, try it check by logging into the DB from command line
(4) restart the alfresco
(5) check the log files for error

Hope it helps
(4) t

[brgsousa]

what about the database initialization?
If I simply change the configuration to a mysql DB, tables won't be created not even populated.

I imagine that the database is populated during the installation process.

[heiko_robert]

the schema/tables are not created by the installer. Alfresco checks during startup if the tables allready exist. If not, they will be created.
Make sure alf_data/contentstore is empty and the created mysql-user can create tables.

[brgsousa]

thanks!! it worked!!!

[brgsousa]

Actually, it is not completely solved.
I think I missed the alf_data folder thing. If I erase it, the application doesn't work at all. So, I am not sure which files/folders to delete.
Nothing weird happened besides of the fact that I can't create categories. They simply don't appear and there are no errors.

So this is a "picture" of the alf_data:

root@debian:/opt/alfresco-4.2.c/alf_data# ls -lR
.:
total 8
drwxr-xr-x 2 root root 4096 Jan 31 18:10 keystore
drwxr-xr-x 7 root root 4096 Jan 31 18:10 solr

./keystore:
total 56
-rw-r–r– 1 root root 2744 Set  3 09:33 browser.p12
-rw-r–r– 1 root root 6276 Set  3 09:33 CreateSSLKeystores.txt
-rw-r–r– 1 root root 6942 Set  3 09:33 generate_keystores.bat
-rwxr-xr-x 1 root root 6615 Set  3 09:33 generate_keystores.sh
-rw-r–r– 1 root root  645 Set  3 09:33 keystore
-rw-r–r– 1 root root  211 Set  3 09:33 keystore-passwords.properties
-rw-r–r– 1 root root  574 Set  3 09:33 readme.txt
-rw-r–r– 1 root root 2756 Set  3 09:33 ssl.keystore
-rw-r–r– 1 root root  253 Set  3 09:33 ssl-keystore-passwords.properties
-rw-r–r– 1 root root  740 Set  3 09:33 ssl.truststore
-rw-r–r– 1 root root  175 Set  3 09:33 ssl-truststore-passwords.properties

./solr:
total 8432
-rw-r–r– 1 root root 4464720 Out 17 08:08 apache-solr-1.4.1.war
-rw-r–r– 1 root root 4101544 Set  3 09:35 apache-solr-1.4.1.war.unpatched
drwxr-xr-x 4 root root    4096 Jan 31 18:10 archive-SpacesStore
-rw-r–r– 1 root root    7105 Set  3 09:35 CreateSSLKeystores.txt
drwxr-xr-x 2 root root    4096 Jan 31 18:10 docs
-rw-r–r– 1 root root    6720 Set  3 09:35 HowToSetUpSolr.txt
drwxr-xr-x 2 root root    4096 Jan 31 18:10 lib
-rw-r–r– 1 root root     247 Set  3 09:35 solr-tomcat-context.xml
-rw-r–r– 1 root root     308 Set  3 09:35 solr.xml
drwxr-xr-x 4 root root    4096 Jan 31 18:10 templates
drwxr-xr-x 4 root root    4096 Jan 31 18:10 workspace-SpacesStore

./solr/archive-SpacesStore:
total 8
drwxr-xr-x 3 root root 4096 Jan 31 18:10 alfrescoResources
drwxr-xr-x 3 root root 4096 Jan 31 18:10 conf

./solr/archive-SpacesStore/alfrescoResources:
total 4
drwxr-xr-x 3 root root 4096 Jan 31 18:10 alfresco

./solr/archive-SpacesStore/alfrescoResources/alfresco:
total 4
drwxr-xr-x 2 root root 4096 Jan 31 18:10 model

./solr/archive-SpacesStore/alfrescoResources/alfresco/model:
total 80
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_cs.properties
-rw-r–r– 1 root root  246 Set  3 09:35 dataTypeAnalyzers_da.properties
-rw-r–r– 1 root root  198 Set  3 09:35 dataTypeAnalyzers_de.properties
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_el.properties
-rw-r–r– 1 root root  250 Set  3 09:35 dataTypeAnalyzers_en.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_es.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_fi.properties
-rw-r–r– 1 root root  198 Set  3 09:35 dataTypeAnalyzers_fr.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_it.properties
-rw-r–r– 1 root root  194 Set  3 09:35 dataTypeAnalyzers_ja.properties
-rw-r–r– 1 root root  194 Set  3 09:35 dataTypeAnalyzers_ko.properties
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_nl.properties
-rw-r–r– 1 root root  252 Set  3 09:35 dataTypeAnalyzers_no.properties
-rw-r–r– 1 root root 1733 Set  3 09:35 dataTypeAnalyzers.properties
-rw-r–r– 1 root root  204 Set  3 09:35 dataTypeAnalyzers_pt_BR.properties
-rw-r–r– 1 root root  254 Set  3 09:35 dataTypeAnalyzers_pt.properties
-rw-r–r– 1 root root  200 Set  3 09:35 dataTypeAnalyzers_ru.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_sv.properties
-rw-r–r– 1 root root  198 Set 17 06:15 dataTypeAnalyzers_th.properties
-rw-r–r– 1 root root  200 Set  3 09:35 dataTypeAnalyzers_zh.properties

./solr/archive-SpacesStore/conf:
total 108
-rw-r–r– 1 root root  1125 Set  3 09:35 admin-extra.html
-rw-r–r– 1 root root  1310 Set  3 09:35 elevate.xml
-rw-r–r– 1 root root  3114 Set  3 09:35 mapping-ISOLatin1Accent.txt
-rw-r–r– 1 root root   894 Set  3 09:35 protwords.txt
-rw-r–r– 1 root root  1254 Set  3 09:35 schema.xml
-rw-r–r– 1 root root   945 Set  3 09:35 scripts.conf
-rw-r–r– 1 root root 48214 Set 17 06:15 solrconfig.xml
-rw-r–r– 1 root root  1923 Jan 31 18:14 solrcore.properties
-rw-r–r– 1 root root    16 Set  3 09:35 spellings.txt
-rw-r–r– 1 root root   267 Set  3 09:35 ssl-keystore-passwords.properties
-rw-r–r– 1 root root  2766 Set  3 09:35 ssl.repo.client.keystore
-rw-r–r– 1 root root   740 Set  3 09:35 ssl.repo.client.truststore
-rw-r–r– 1 root root   175 Set  3 09:35 ssl-truststore-passwords.properties
-rw-r–r– 1 root root  1229 Set  3 09:35 stopwords.txt
-rw-r–r– 1 root root  1163 Set  3 09:35 synonyms.txt
drwxr-xr-x 2 root root  4096 Jan 31 18:10 xslt

./solr/archive-SpacesStore/conf/xslt:
total 32
-rw-r–r– 1 root root  2592 Set  3 09:35 example_atom.xsl
-rw-r–r– 1 root root  2370 Set  3 09:35 example_rss.xsl
-rw-r–r– 1 root root  4287 Set  3 09:35 example.xsl
-rw-r–r– 1 root root 13769 Set  3 09:35 luke.xsl

./solr/docs:
total 44
-rw-r–r– 1 root root    11 Set  3 09:35 commit.xml
-rw-r–r– 1 root root    12 Set  3 09:35 optimize.xml
-rw-r–r– 1 root root 32571 Set  3 09:35 test-1-add.xml
-rw-r–r– 1 root root   857 Set  3 09:35 test-1-delete.xml

./solr/lib:
total 27936
-rw-r–r– 1 root root  320871 Set  3 09:36 acegi-security-0.8.2_patched.jar
-rw-r–r– 1 root root  321500 Dez 10 20:50 alfresco-core-4.2.c.jar
-rw-r–r– 1 root root 1231734 Dez 10 20:50 alfresco-data-model-4.2.c.jar
-rw-r–r– 1 root root  417543 Dez 10 20:50 alfresco-solr-integration-4.2.c.jar
-rw-r–r– 1 root root 1323005 Set  3 09:36 ant-1.7.1.jar
-rw-r–r– 1 root root 2388361 Set  3 09:36 antlr-3.4-complete.jar
-rw-r–r– 1 root root   63251 Set  3 09:36 chemistry-abdera-0.1-incubating-SNAPSHOT.jar
-rw-r–r– 1 root root   30510 Nov 15 18:50 chemistry-opencmis-client-api-0.8.0.jar
-rw-r–r– 1 root root  272916 Nov 15 18:50 chemistry-opencmis-client-bindings-0.8.0.jar
-rw-r–r– 1 root root  140854 Nov 15 18:50 chemistry-opencmis-client-impl-0.8.0.jar
-rw-r–r– 1 root root   92896 Nov 15 18:50 chemistry-opencmis-commons-api-0.8.0.jar
-rw-r–r– 1 root root  461427 Nov 15 18:50 chemistry-opencmis-commons-impl-0.8.0.jar
-rw-r–r– 1 root root  206185 Nov 15 18:50 chemistry-opencmis-server-bindings-0.8.0.jar
-rw-r–r– 1 root root  263372 Nov 15 18:50 chemistry-opencmis-server-support-0.8.0.jar
-rw-r–r– 1 root root   14039 Nov 15 18:50 chemistry-opencmis-test-browser-0.8.0.jar
-rw-r–r– 1 root root  168809 Nov 15 18:50 chemistry-opencmis-test-tck-0.8.0.jar
-rw-r–r– 1 root root   73098 Set  3 09:36 commons-codec-1.5.jar
-rw-r–r– 1 root root  575389 Set  3 09:36 commons-collections-3.2.1.jar
-rw-r–r– 1 root root  305001 Set  3 09:36 commons-httpclient-3.1.jar
-rw-r–r– 1 root root  109043 Set  3 09:36 commons-io-1.4.jar
-rw-r–r– 1 root root   60686 Set  3 09:36 commons-logging-1.1.1.jar
-rw-r–r– 1 root root  313898 Set  3 09:36 dom4j-1.6.1.jar
-rw-r–r– 1 root root    4957 Set  3 09:36 guessencoding-1.0.jar
-rw-r–r– 1 root root 2277162 Set  3 09:36 hibernate-3.2.6-patched.jar
-rw-r–r– 1 root root  866993 Set  3 09:36 jaxb-impl-2.1.11.jar
-rw-r–r– 1 root root 3126580 Set  3 09:36 jaxb-xjc-2.1.7.jar
-rw-r–r– 1 root root  223395 Set  3 09:36 jaxen-1.1.3.jar
-rw-r–r– 1 root root  244221 Set  3 09:36 jboss-vfs-2.1.0.GA.jar
-rw-r–r– 1 root root  136348 Set  3 09:36 jibx-run.jar
-rw-r–r– 1 root root   46233 Set  3 09:36 json.jar
-rw-r–r– 1 root root    8809 Set  3 09:36 jta.jar
-rw-r–r– 1 root root   31906 Set  3 09:36 jug-asl-2.0.0.jar
-rw-r–r– 1 root root  241258 Set 26 17:36 junit-dep-4.11-SNAPSHOT-20120805-1225.jar
-rw-r–r– 1 root root  391834 Set  3 09:36 log4j-1.2.15.jar
-rw-r–r– 1 root root  144607 Set  3 09:36 lucene-analyzers-2.4.1.jar
-rw-r–r– 1 root root  822794 Set  3 09:36 lucene-core-2.4.1.jar
-rw-r–r– 1 root root   13238 Set  3 09:36 lucene-regex-2.4.1.jar
-rw-r–r– 1 root root  113732 Set  3 09:36 lucene-snowball-2.4.1.jar
-rw-r–r– 1 root root 1312472 Set  3 09:36 mockito-all-1.8.0.jar
-rw-r–r– 1 root root  650218 Set  3 09:36 mybatis-3.0.4-patched.jar
-rw-r–r– 1 root root   34985 Set  3 09:36 mybatis-spring-1.0.1.jar
-rw-r–r– 1 root root  321190 Set  3 09:36 org.springframework.aop-3.0.5.RELEASE.jar
-rw-r–r– 1 root root   53082 Set  3 09:36 org.springframework.asm-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  555410 Set  3 09:36 org.springframework.beans-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  668861 Set  3 09:36 org.springframework.context-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  100870 Set  3 09:36 org.springframework.context.support-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  382442 Set  3 09:36 org.springframework.core-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  169752 Set  3 09:36 org.springframework.expression-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  385712 Set  3 09:36 org.springframework.jdbc-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  334327 Set  3 09:36 org.springframework.orm-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  231922 Set  3 09:36 org.springframework.transaction-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  395587 Set  3 09:36 org.springframework.web-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  418977 Set  3 09:36 org.springframework.web.servlet-3.0.5.RELEASE.jar
-rw-r–r– 1 root root  450817 Set  3 09:36 quartz-1.8.3-patched.jar
-rw-r–r– 1 root root   98719 Set  3 09:36 servlet.jar
-rw-r–r– 1 root root   23671 Set  3 09:36 slf4j-api-1.5.11.jar
-rw-r–r– 1 root root    9693 Set  3 09:36 slf4j-log4j12-1.5.11.jar
-rw-r–r– 1 root root  749586 Dez  6 03:10 spring-surf-1.2.0-SNAPSHOT.jar
-rw-r–r– 1 root root   37696 Nov 21 13:20 spring-surf-api-1.2.0-SNAPSHOT.jar
-rw-r–r– 1 root root   35348 Dez  6 03:10 spring-surf-core-1.2.0-SNAPSHOT.jar
-rw-r–r– 1 root root   44109 Nov 21 13:20 spring-surf-core-configservice-1.2.0-SNAPSHOT.jar
-rw-r–r– 1 root root   76573 Nov 21 13:20 spring-webeditor-1.2.0-SNAPSHOT.jar
-rw-r–r– 1 root root   10333 Nov 21 13:20 spring-webeditor-client-jsp-1.2.0-SNAPSHOT.jar
-rw-r–r– 1 root root  507590 Nov 21 13:20 spring-webscripts-1.2.0-SNAPSHOT.jar
-rw-r–r– 1 root root   76492 Set  3 09:36 spring-webscripts-1.2.0-SNAPSHOT-tests.jar
-rw-r–r– 1 root root   68908 Nov 21 13:20 spring-webscripts-api-1.2.0-SNAPSHOT.jar
-rw-r–r– 1 root root   26514 Set  3 09:36 stax-api-1.0.1.jar
-rw-r–r– 1 root root  471764 Nov  5 01:00 tika-core-1.3-20121030.jar
-rw-r–r– 1 root root  483909 Nov  5 01:00 tika-parsers-1.3-20121030.jar
-rw-r–r– 1 root root 1207073 Set  3 09:36 xercesImpl-2.8.0.jar

./solr/templates:
total 8
drwxr-xr-x 4 root root 4096 Jan 31 18:10 store
drwxr-xr-x 5 root root 4096 Jan 31 18:10 test

./solr/templates/store:
total 8
drwxr-xr-x 3 root root 4096 Jan 31 18:10 alfrescoResources
drwxr-xr-x 3 root root 4096 Jan 31 18:10 conf

./solr/templates/store/alfrescoResources:
total 4
drwxr-xr-x 3 root root 4096 Jan 31 18:10 alfresco

./solr/templates/store/alfrescoResources/alfresco:
total 4
drwxr-xr-x 2 root root 4096 Jan 31 18:10 model

./solr/templates/store/alfrescoResources/alfresco/model:
total 80
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_cs.properties
-rw-r–r– 1 root root  246 Set  3 09:35 dataTypeAnalyzers_da.properties
-rw-r–r– 1 root root  198 Set  3 09:35 dataTypeAnalyzers_de.properties
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_el.properties
-rw-r–r– 1 root root  250 Set  3 09:35 dataTypeAnalyzers_en.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_es.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_fi.properties
-rw-r–r– 1 root root  198 Set  3 09:35 dataTypeAnalyzers_fr.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_it.properties
-rw-r–r– 1 root root  194 Set  3 09:35 dataTypeAnalyzers_ja.properties
-rw-r–r– 1 root root  194 Set  3 09:35 dataTypeAnalyzers_ko.properties
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_nl.properties
-rw-r–r– 1 root root  252 Set  3 09:35 dataTypeAnalyzers_no.properties
-rw-r–r– 1 root root 1733 Set  3 09:35 dataTypeAnalyzers.properties
-rw-r–r– 1 root root  204 Set  3 09:35 dataTypeAnalyzers_pt_BR.properties
-rw-r–r– 1 root root  254 Set  3 09:35 dataTypeAnalyzers_pt.properties
-rw-r–r– 1 root root  200 Set  3 09:35 dataTypeAnalyzers_ru.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_sv.properties
-rw-r–r– 1 root root  198 Set 17 06:15 dataTypeAnalyzers_th.properties
-rw-r–r– 1 root root  200 Set  3 09:35 dataTypeAnalyzers_zh.properties

./solr/templates/store/conf:
total 108
-rw-r–r– 1 root root  1094 Set  3 09:35 admin-extra.html
-rw-r–r– 1 root root  1274 Set  3 09:35 elevate.xml
-rw-r–r– 1 root root  2868 Set  3 09:35 mapping-ISOLatin1Accent.txt
-rw-r–r– 1 root root   873 Set  3 09:35 protwords.txt
-rw-r–r– 1 root root  1228 Set  3 09:35 schema.xml
-rw-r–r– 1 root root   921 Set  3 09:35 scripts.conf
-rw-r–r– 1 root root 47113 Set 17 06:15 solrconfig.xml
-rw-r–r– 1 root root  2021 Nov 27 07:50 solrcore.properties
-rw-r–r– 1 root root    14 Set  3 09:35 spellings.txt
-rw-r–r– 1 root root   267 Set  3 09:35 ssl-keystore-passwords.properties
-rw-r–r– 1 root root  2766 Set  3 09:35 ssl.repo.client.keystore
-rw-r–r– 1 root root   740 Set  3 09:35 ssl.repo.client.truststore
-rw-r–r– 1 root root   175 Set  3 09:35 ssl-truststore-passwords.properties
-rw-r–r– 1 root root  1171 Set  3 09:35 stopwords.txt
-rw-r–r– 1 root root  1132 Set  3 09:35 synonyms.txt
drwxr-xr-x 2 root root  4096 Jan 31 18:10 xslt

./solr/templates/store/conf/xslt:
total 32
-rw-r–r– 1 root root  2525 Set  3 09:35 example_atom.xsl
-rw-r–r– 1 root root  2304 Set  3 09:35 example_rss.xsl
-rw-r–r– 1 root root  4155 Set  3 09:35 example.xsl
-rw-r–r– 1 root root 13432 Set  3 09:35 luke.xsl

./solr/templates/test:
total 12
drwxr-xr-x 2 root root 4096 Jan 31 18:10 alfrescoModels
drwxr-xr-x 3 root root 4096 Jan 31 18:10 alfrescoResources
drwxr-xr-x 3 root root 4096 Jan 31 18:10 conf

./solr/templates/test/alfrescoModels:
total 456
-rw-r–r– 1 root root 13736 Set  3 09:35 act.actionmodel.2333400144.xml
-rw-r–r– 1 root root  5898 Set  3 09:35 app.applicationmodel.2129666659.xml
-rw-r–r– 1 root root  5188 Set  3 09:35 blg.blogintegration.618287660.xml
-rw-r–r– 1 root root 16793 Set  3 09:35 bpm.businessprocessmodel.3425263418.xml
-rw-r–r– 1 root root 72434 Set  3 09:35 cm.contentmodel.3796578482.xml
-rw-r–r– 1 root root 16460 Set  3 09:35 cmis.cmismodel.1130431862.xml
-rw-r–r– 1 root root  2982 Set  3 09:35 cmiscustom.model.4244003081.xml
-rw-r–r– 1 root root 13344 Set  3 09:35 cmistest.cmis-query-test.0.xml
-rw-r–r– 1 root root   562 Set  3 09:35 custom.customModel.1697115130.xml
-rw-r–r– 1 root root  6059 Set  3 09:35 d.dictionary.322997055.xml
-rw-r–r– 1 root root 22559 Set  3 09:35 dl.datalistmodel.1706682851.xml
-rw-r–r– 1 root root  2616 Set  3 09:35 emailserver.emailserverModel.1829575680.xml
-rw-r–r– 1 root root  1755 Set  3 09:35 facebook.publishingmodel.2801754874.xml
-rw-r–r– 1 root root  1684 Set  3 09:35 flickr.publishingmodel.3293081165.xml
-rw-r–r– 1 root root  2797 Set  3 09:35 fm.forummodel.487334574.xml
-rw-r–r– 1 root root  2221 Set  3 09:35 gd.googledocs.2441566572.xml
-rw-r–r– 1 root root  7177 Set  3 09:35 ia.CalendarEventModel.2073457164.xml
-rw-r–r– 1 root root  8094 Set  3 09:35 imap.imapmodel.2049525383.xml
-rw-r–r– 1 root root  4515 Set  3 09:35 imwf.invitation-moderated-workflow-model.2664371924.xml
-rw-r–r– 1 root root  7805 Set  3 09:35 inwf.invite-workflow-model.3015846089.xml
-rw-r–r– 1 root root  6089 Set  3 09:35 jcr.jcrmodel.3095374570.xml
-rw-r–r– 1 root root  1704 Set  3 09:35 linkedin.publishingmodel.722573125.xml
-rw-r–r– 1 root root  2086 Set  3 09:35 lnk.linksmodel.491689872.xml
-rw-r–r– 1 root root 18571 Set  3 09:35 pub.publishingmodel.4136228621.xml
-rw-r–r– 1 root root  1203 Set  3 09:35 pubwf.workflowModel.3544877799.xml
-rw-r–r– 1 root root  3454 Set  3 09:35 rule.rulemodel.464956843.xml
-rw-r–r– 1 root root  2141 Set  3 09:35 slideshare.publishingmodel.4141572456.xml
-rw-r–r– 1 root root  2958 Set  3 09:35 st.siteModel.4185002801.xml
-rw-r–r– 1 root root 12252 Set  3 09:35 sys.systemmodel.2112428407.xml
-rw-r–r– 1 root root 17193 Set  3 09:35 test.solrtest.0.xml
-rw-r–r– 1 root root 11605 Set  3 09:35 trx.applicationmodel.3607405828.xml
-rw-r–r– 1 root root  1390 Set  3 09:35 tst.testversionable.3479565850.xml
-rw-r–r– 1 root root  1694 Set  3 09:35 twitter.publishingmodel.917882747.xml
-rw-r–r– 1 root root  5308 Set  3 09:35 usr.usermodel.3005240662.xml
-rw-r–r– 1 root root  7969 Set  3 09:35 ver2.versionmodel.397464833.xml
-rw-r–r– 1 root root  8979 Set  3 09:35 ver.versionmodel.407312229.xml
-rw-r–r– 1 root root 32403 Set  3 09:35 wca.applicationmodel.769947672.xml
-rw-r–r– 1 root root  3449 Set  3 09:35 wcm.wcmmodel.2095815059.xml
-rw-r–r– 1 root root 14474 Set  3 09:35 wcmwf.workflowmodel.980726980.xml
-rw-r–r– 1 root root 10829 Set  3 09:35 wf.workflowmodel.2672146310.xml
-rw-r–r– 1 root root  2095 Set  3 09:35 youtube.publishingmodel.2267102847.xml

./solr/templates/test/alfrescoResources:
total 4
drwxr-xr-x 3 root root 4096 Jan 31 18:10 alfresco

./solr/templates/test/alfrescoResources/alfresco:
total 4
drwxr-xr-x 2 root root 4096 Jan 31 18:10 model

./solr/templates/test/alfrescoResources/alfresco/model:
total 80
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_cs.properties
-rw-r–r– 1 root root  246 Set  3 09:35 dataTypeAnalyzers_da.properties
-rw-r–r– 1 root root  198 Set  3 09:35 dataTypeAnalyzers_de.properties
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_el.properties
-rw-r–r– 1 root root  250 Set  3 09:35 dataTypeAnalyzers_en.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_es.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_fi.properties
-rw-r–r– 1 root root  198 Set  3 09:35 dataTypeAnalyzers_fr.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_it.properties
-rw-r–r– 1 root root  194 Set  3 09:35 dataTypeAnalyzers_ja.properties
-rw-r–r– 1 root root  194 Set  3 09:35 dataTypeAnalyzers_ko.properties
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_nl.properties
-rw-r–r– 1 root root  252 Set  3 09:35 dataTypeAnalyzers_no.properties
-rw-r–r– 1 root root 1733 Set  3 09:35 dataTypeAnalyzers.properties
-rw-r–r– 1 root root  204 Set  3 09:35 dataTypeAnalyzers_pt_BR.properties
-rw-r–r– 1 root root  254 Set  3 09:35 dataTypeAnalyzers_pt.properties
-rw-r–r– 1 root root  200 Set  3 09:35 dataTypeAnalyzers_ru.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_sv.properties
-rw-r–r– 1 root root  198 Set 17 06:15 dataTypeAnalyzers_th.properties
-rw-r–r– 1 root root  200 Set  3 09:35 dataTypeAnalyzers_zh.properties

./solr/templates/test/conf:
total 108
-rw-r–r– 1 root root  1125 Set  3 09:35 admin-extra.html
-rw-r–r– 1 root root  1310 Set  3 09:35 elevate.xml
-rw-r–r– 1 root root  3114 Set  3 09:35 mapping-ISOLatin1Accent.txt
-rw-r–r– 1 root root   894 Set  3 09:35 protwords.txt
-rw-r–r– 1 root root  1254 Set  3 09:35 schema.xml
-rw-r–r– 1 root root   945 Set  3 09:35 scripts.conf
-rw-r–r– 1 root root 48221 Set 17 06:15 solrconfig.xml
-rw-r–r– 1 root root  2119 Nov 27 07:50 solrcore.properties
-rw-r–r– 1 root root    16 Set  3 09:35 spellings.txt
-rw-r–r– 1 root root   273 Set  3 09:35 ssl-keystore-passwords.properties
-rw-r–r– 1 root root  2766 Set  3 09:35 ssl.repo.client.keystore
-rw-r–r– 1 root root   740 Set  3 09:35 ssl.repo.client.truststore
-rw-r–r– 1 root root   179 Set  3 09:35 ssl-truststore-passwords.properties
-rw-r–r– 1 root root  1229 Set  3 09:35 stopwords.txt
-rw-r–r– 1 root root  1163 Set  3 09:35 synonyms.txt
drwxr-xr-x 2 root root  4096 Jan 31 18:10 xslt

./solr/templates/test/conf/xslt:
total 32
-rw-r–r– 1 root root  2592 Set  3 09:35 example_atom.xsl
-rw-r–r– 1 root root  2370 Set  3 09:35 example_rss.xsl
-rw-r–r– 1 root root  4287 Set  3 09:35 example.xsl
-rw-r–r– 1 root root 13769 Set  3 09:35 luke.xsl

./solr/workspace-SpacesStore:
total 8
drwxr-xr-x 3 root root 4096 Jan 31 18:10 alfrescoResources
drwxr-xr-x 3 root root 4096 Jan 31 18:10 conf

./solr/workspace-SpacesStore/alfrescoResources:
total 4
drwxr-xr-x 3 root root 4096 Jan 31 18:10 alfresco

./solr/workspace-SpacesStore/alfrescoResources/alfresco:
total 4
drwxr-xr-x 2 root root 4096 Jan 31 18:10 model

./solr/workspace-SpacesStore/alfrescoResources/alfresco/model:
total 80
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_cs.properties
-rw-r–r– 1 root root  246 Set  3 09:35 dataTypeAnalyzers_da.properties
-rw-r–r– 1 root root  198 Set  3 09:35 dataTypeAnalyzers_de.properties
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_el.properties
-rw-r–r– 1 root root  250 Set  3 09:35 dataTypeAnalyzers_en.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_es.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_fi.properties
-rw-r–r– 1 root root  198 Set  3 09:35 dataTypeAnalyzers_fr.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_it.properties
-rw-r–r– 1 root root  194 Set  3 09:35 dataTypeAnalyzers_ja.properties
-rw-r–r– 1 root root  194 Set  3 09:35 dataTypeAnalyzers_ko.properties
-rw-r–r– 1 root root  196 Set  3 09:35 dataTypeAnalyzers_nl.properties
-rw-r–r– 1 root root  252 Set  3 09:35 dataTypeAnalyzers_no.properties
-rw-r–r– 1 root root 1733 Set  3 09:35 dataTypeAnalyzers.properties
-rw-r–r– 1 root root  204 Set  3 09:35 dataTypeAnalyzers_pt_BR.properties
-rw-r–r– 1 root root  254 Set  3 09:35 dataTypeAnalyzers_pt.properties
-rw-r–r– 1 root root  200 Set  3 09:35 dataTypeAnalyzers_ru.properties
-rw-r–r– 1 root root  248 Set  3 09:35 dataTypeAnalyzers_sv.properties
-rw-r–r– 1 root root  198 Set 17 06:15 dataTypeAnalyzers_th.properties
-rw-r–r– 1 root root  200 Set  3 09:35 dataTypeAnalyzers_zh.properties

./solr/workspace-SpacesStore/conf:
total 108
-rw-r–r– 1 root root  1094 Set  3 09:35 admin-extra.html
-rw-r–r– 1 root root  1274 Set  3 09:35 elevate.xml
-rw-r–r– 1 root root  2868 Set  3 09:35 mapping-ISOLatin1Accent.txt
-rw-r–r– 1 root root   873 Set  3 09:35 protwords.txt
-rw-r–r– 1 root root  1228 Set  3 09:35 schema.xml
-rw-r–r– 1 root root   921 Set  3 09:35 scripts.conf
-rw-r–r– 1 root root 47106 Set 17 06:15 solrconfig.xml
-rw-r–r– 1 root root  2388 Jan 31 18:14 solrcore.properties
-rw-r–r– 1 root root    14 Set  3 09:35 spellings.txt
-rw-r–r– 1 root root   267 Set  3 09:35 ssl-keystore-passwords.properties
-rw-r–r– 1 root root  2766 Set  3 09:35 ssl.repo.client.keystore
-rw-r–r– 1 root root   740 Set  3 09:35 ssl.repo.client.truststore
-rw-r–r– 1 root root   175 Set  3 09:35 ssl-truststore-passwords.properties
-rw-r–r– 1 root root  1171 Set  3 09:35 stopwords.txt
-rw-r–r– 1 root root  1132 Set  3 09:35 synonyms.txt
drwxr-xr-x 2 root root  4096 Jan 31 18:10 xslt

./solr/workspace-SpacesStore/conf/xslt:
total 32
-rw-r–r– 1 root root  2525 Set  3 09:35 example_atom.xsl
-rw-r–r– 1 root root  2304 Set  3 09:35 example_rss.xsl
-rw-r–r– 1 root root  4155 Set  3 09:35 example.xsl
-rw-r–r– 1 root root 13432 Set  3 09:35 luke.xsl



Do you know which content to delete?

[bisana]

See, just after finishing the installation(do not start the instance). you copy alf_data/contentstore*.* from the backup directory to the newly installed instance 'alf_data'