Moving the Database to another machine

[Mag]

Hi,

I needed to change the database to another machine.

* S, I did backup mySQL database
* as Admin. I did backup SugarCRM (ini order to keep all the config)

Then, on the other machine :
* restored MySQL database
* Unlock the SugarCRM Locker (into the config.php)
and execute the install

Filled in all the questions....
And it asked me the http link !!! (like http://192.168.x.x )

I am a bit surtprise . I thought that it was link to the web browser to reach the database !?
If I need to change the IP address of my server, => does it mean that I won't be able to reach SugarCRM ?

After the installation, where can I change this IP value ?

THanks

[stevec]

There are a couple of IP addresses in the config file that the installer sets up (the config file is in the root directory of the sugar install and is called config.php). these are the IP address of the database server (set to 127.0.0.1 if the database is on the same machine as the webserver) and the IP address of the webserver itself (so the application knows where it is).

If you've moved server to one with a new IP address, you will need to alter this to reflect the change.



An alternative way to migrate an install is to install the backed up SQL database on the machine. Back up the whole sugarcrm file structure and restore that onto the new server. Then edit the config.php file to reflect the new server IP. (making sure you repeat any changes you made to the mysql and php configs if you changed them from the default).

[cmarcus]

I'm facing a slightly different challenge. I seek to move SugarCRM data from one machine to another - SugarCRM was successfully installed on the destination machine, but I can't figure out how to import the database export from the first machine. I used PHPMyAdmin to export the entire SugarCRM MySQL database - but in PHPMyAdmin on the new machine I can't find any "import" function. I don't have command line access (the new machine is hosted at GoDaddy). Any tips? Thanks!

[paikmoses]

I'm facing a slightly different challenge. I seek to move SugarCRM data from one machine to another - SugarCRM was successfully installed on the destination machine, but I can't figure out how to import the database export from the first machine. I used PHPMyAdmin to export the entire SugarCRM MySQL database - but in PHPMyAdmin on the new machine I can't find any "import" function. I don't have command line access (the new machine is hosted at GoDaddy). Any tips? Thanks!

Hi cmarcus,

Using phpMyAdmin, first of all you have to create a database and after that you click on the SQL tab on the top. It will take you to the import page from where you can browse and upload the files from your local machine.

By the way GoDaddy provides the command line access.

Hope this helps.

Regards,

[malcolmh]

I'm facing a slightly different challenge. I seek to move SugarCRM data from one machine to another - SugarCRM was successfully installed on the destination machine, but I can't figure out how to import the database export from the first machine. I used PHPMyAdmin to export the entire SugarCRM MySQL database - but in PHPMyAdmin on the new machine I can't find any "import" function.

With the newer phpMyAdmin versions there is an import function, which we have used quite heavily (appears on the Home Page ). You should talk to your hosting company, perhaps they are using an older version.