[opencms-dev] installing opencms while preserving an existing database

[Philip Kuegler]

Hi,

if the new setup is _identical_ (including IP information) to the old 
one (paths, opencms version, configuration) it should be working as a 
simple copy (and overwrite) action. Just overwrite the database and the 
app directory of the new server with the data from the old one. After 
shutting down mysql ("mysql stop") you can simply tar ("tar -zcf 
mydatabase.tar.gz /var/lib/mysql/$database") the database and untar it 
on the target server. You should migrate the opencms directory too to be 
sure that the whole configuration is identical because otherwise opencms 
might have problems reading modified objects.

So:
  1.) Do a full setup on the new server
  2.) Shut down tomcat and mysql (on both servers)
  3.) Overwrite the target server with the files from the current one 
(mysql, opencms). If IP information has changed take a closer look at 
the contents of (var/lib/tomcat/webapps/opencms/WEB-INF/conf/*).
  4.) Check "opencms/WEB-INF/conf/opencms.properties" if the database 
config does fit the new environment
  5.) Check "opencms/WEB-INF/conf/opencms-system.xml" if the mailhost 
config and site config is still ok
  6.) Startup the new server.

br,
Philip

Jaleel, Jehan wrote:
>
> Hi all,
>
>           When you first install opencms on your app server it prompts 
> you for the database information, when you provide it with this, it 
> then creates the opencms database tables.
>
>  
>
>           I was wondering if there was anyway to install opencms on 
> top of an existing opencms database. My problem is that I already have 
> opencms running on one server but I want to move it to a different 
> server, meantime I do not want to lose all my data. I want the new 
> installation to user the old installation's tables. Is this possible.
>
>  
>
> Thanks in advance for any help,
>
> Jehan
>
> ------------------------------------------------------------------------
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20081025/257c2ba7/attachment.htm>