Cloning Sugarcrm

[Shuchi]

Hi,

I need to copy the CRM to a different linux box.I followed the bitrock installation initially.
Could someone guide me how to go about copying the whole CRM system(with the DB) on a different server without losing any data.
Also, which config files need to be modified ???

Thanks in advance......

[rliebscher]

Hi

All data from SugarCRM ar stored in database and all configurations/modifcations in files in the sugarcrm-directory.

So u can make a complete database-backup (easy over myswl-administrator) and restore this backup on the other server.

U have to setup php like on the old system (keep an eye on php.ini).

Setup sugarcrm on the new server (point to ur restored database) and then make an alignment between old and new sugarcrm-directory to get ur custom modifications to the files.

Maybe u have to migrate custom fields (if u have) over the admin-panel (export->import), but dont know if this is already done by database-backup. (custom-field-definitions r stored in db)

I have never done this, but i think, this should work.

Maybe somebody has better solution

Ronny

PS: There is a backup-panel under admin, but dont use this. It makes a copy of the SugarCRM-directory in a zip-file.
Even i tested this and the backup has forgotten some files. Better do this manually.

[Shuchi]

Sounds a wee bit complicated for a newbie like me..but will give it a shot.

Thanks for the reply,Ronny

PS: Thanks for the tip!

[rliebscher]

Sure, it is easy.

Download the SQLAdministrator to make the database-backup. Its real easy with this tool.

If u restored the database on ur new server, u can setup sugarcrm, like u did it on the old server.

If u have, u can use a comparetool like beyond&compare or ultracompare to compare ur new sugar-directory with the old one and transfer ur modified files.

Ronny

[Shuchi]

At the moment i am using mysqldump for back-up...also i used bitrock for installation.
Sorry if it is s dumb question....does that mean, i reinstall sugarcrm and reload the data in the new DB.

[rliebscher]

yep, that it means.

But i recommend u, to restore the db first and then setup sugarcrm.

in setup u can choose the db for sugarcrm, so u dont have to create a new one and all should be fine.

But like i say, i did not prove this.

If u have success, please post it

Ronny

[Shuchi]

i sure will post if it works and any other problems i encounter...

[rbemrose]

I use the following code to make a hot backup of our production tree to the development tree. The script takes care of the configuration file, default web address and changes the company logo.

It can be easily modified to clone to another system.

I hope this help.

 #!/bin/sh
 # Description: make hot backup of the production tree to development tree
 # Author: Richard Bemrose, http://www.cambridgeonline.net
 # Assumptions:
 #   Production SugarCRM in "prod" directory
 #   Production database "sugarcrmprod"
 #   Production URL http://10.99.101.14
 #   Development SugarCRM in "dev" directory
 #   Development database "sugarcrmdev"
 #   Development URL http://10.99.101.14/dev
 
 echo removing development tree
 \rm -rf dev
 
 echo copying production to development sugarcrm
 cp -rp prod dev
 cd dev
 
 echo making changes to config.php
 perl -p -i.bak -e 's/sugarcrmprod/sugarcrmdev/g' config.php
 perl -p -i.bak -e 's/http:\/\/10.99.101.14/http:\/\/10.99.101.14\/dev\//g' config.php
 
 # make the uses aware they are using the development tree
 cd themes
 for dir in *; do
    \cp /opt/sugarcrm/images/developement-sugarcrm-large.png $dir/images/company_logo.png
 done
 
 mysqladmin -f drop sugarcrmdev
 
 echo making hot backup of prod to dev
 mysqlhotcopy -q sugarcrmprod sugarcrmdev

Regards,
Rich