Cloning Sugar - to run from same server

[Deland02]

Hi,

Could anyone offer me any help on cloning my current Sugar setup? I need to clone Sugar to run on the same server as the current Sugar instance. So the first question is can this be done? If so how would I go about duplicating it?

Sugar was already installed onto the server by someone else who I believe set Sugar up manually i.e. installed MySQL, Then PHP, Apache etc so it wasn’t set up with the Bitrock installer. I also have MySQL admin installed & we currently have a daily backup which I set up.

I searched and there are a few posts I found on cloning Sugar onto another server but I want to run it from the same server if possible as the second Sugar will be a test only system.

Is anyone able to help at all?





.

[pblag]

HI!

As I understand you need second machine with sugarcrm.

I can say that it is simple to do.

You just have to copy sugar files and database to another computer.
For copying databases i recommend to use SQLYog.

Sure you have to install PHP Mysql and Apache onto new server.
I do recommend to install latest SugarCRM installation package (with PHP MYsql and Apache) (around 90 MB)
After that you can copy your files to new machine.

Sure you have to update config.php file. (change db settings)

If you still need help we can help you,

you can leave us a message here
http://www.blagodir.com/index.php?mo...s&action=index

Regards,
Petro Blagodir.
pblag@blagodir.com
http://www.blagodir.com

[daggerhart]

Hi,

Could anyone offer me any help on cloning my current Sugar setup? I need to clone Sugar to run on the same server as the current Sugar instance. So the first question is can this be done? If so how would I go about duplicating it?
.

Files -
Copy the current sugar folder to another folder w/ diff name.
( ie. copy c:\apache\htdocs\sugarcrm c:\apache\htdocs\sugarClone )
-----------------------
Database - 2 options
1) phpmyadmin:
Export the database's tables.
make new database
Import the previously exported tables.

2) mysqldump:
(1 database) mysqldump --user=username --password=password --opt DB_NAME > nameOfFile.sql
Then edit the .sql file.
At the top find:

--
-- Current Database: `sugarcrm`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sugarcrm` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `sugarcrm`;

Change each instance of 'sugarcrm' to 'sugarclone' ... orwahtever you want to name your database.
Save the file.

mysqldump --user=username --password=password DB_NAME < nameOfFile.sql
----------------------

After copying the files & the database, you'll need to edit config.inc.php in the new folder and change;
'db_name' => 'sugarcrm',
to 'db_name' => 'sugarclone',
save it.

Then you should have a working cloned instance.

[Deland02]

I knew it was possible from the same server but just wasn’t sure of the exact details.

The problem is I am a complete beginner when it comes to SQL & PHP. Are you saying I need to do both steps or pick one of the 2?

I have My SQL Admin installed but not sure about PHP Admin. How can I find out if I have PHP Admin?

[daggerhart]

Just pick one of the 2.

Im not familiar with MySQL Admin, but phpmyadmin is a php app that lets you handle mySQL in a webbrowser.

If you don't have phpmyadmin, I would recommend the mysqldump.

To run mysqldump you have to be in the right folder.
(i.e. C:\Program Files\Mysql\Mysql 5 Server\bin )

[Deland02]

Right then,

MyPHP Admin installed.
I created a new utf8_unicode_ci database - same as the current sugrcrm database.
Exported the database structure & data from my current sugarcrm database.
Imported the structure & data into my new 'sugarcrm_testing' database
Found the 'config.inc.php' files in my cloned site folders.
One config file is completely empty and the other one says the following:

<?php

/* $Id: config.sample.inc.php 9675 2006-11-03 09:06:06Z nijel $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.cihar.com>.
*/

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'ihatesugar'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'Chariot1';
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

I cant see where it mentions about 'db_name' => 'sugarcrm'

Also you mentioned I had to change all the instances of where it says ‘sugarcrm’. Is this in every PHP file in the new htdocs folder?




.