Hi Vimal,
you can setup mysql repositories.
You need the mysql-connector lib, e.g. mysql-connector-java-5.0.5-bin.jar
put this to the tomcat /common/libs
config
/magnoliaAuthor/WEB-INF/config/default/magnolia.properties
magnolia.repositories.jackrabbit.config=WEB-INF/config/repo-conf/jackrabbit-mysql-search.xml
/magnoliaAuthor/WEB-INF/config/repo-conf/jackrabbit-mysql-search.xml
setup url, user and password, to times in this file!
/magnoliaPublic/WEB-INF/config/default/magnolia.properties
magnolia.repositories.jackrabbit.config=WEB-INF/config/repo-conf/jackrabbit-mysql-search.xml
/magnoliaPublic/WEB-INF/config/repo-conf/jackrabbit-mysql-search.xml
setup url, user and password, to times in this file!
delete the old repositories webapps/magnoliaXXX/repositories/magnolia
Start mysql and create the db for magnoliaAuthor and magnoliaPublic.
Start tomcat, at now it creates the repositories in mysql.
Now you can backup these db-spaces for further use.
Another way to use mysql is described at
http://www.magnolia.info/wiki/Wiki.jsp?page=SettingUpMySQLRepositoryWithMagnolia3.1
You can use the Export/Import in Magnolia Tools, but I didn't test
it in the case you need. Didn't know how to reconnect older
repositories at now, maybe you have to backup the files in
webapps/magnoliaXXX/repositories/magnolia too - after the
dbs are created, shutdown tomcat for this.
Maybe it helps
Greetz
Uwe
BV> Many thanks for your reply. I understand by redeploying the war file the
BV> internal derby db also get deleted and replaced.
BV> Is there any way to import table schemas and initial data in to a
BV> database (MySql/postgresql instead of derby)?
BV> Thanks in advance
BV> Vimal Bansal
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
