To move SugarCRM from one server to another:
(If this article was helpful, please vote at the bottom.)
1. Perform a mysqldump of the SugarCRM MySQL database, or export the database from phpmyadmin
$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
2. Import the mysql database into the new server
$ mysql -u [uname] -p[pass] [dbname] < [backupfile.sql]
3. Go into the <sugarroot/config.php> and make sure that all settings still apply to the new server, such as:
array (
'db_host_name' => 'localhost',
'db_user_name' => 'root',
'db_password' => 'PASSWORD',
'db_name' => 'DATABASE_NAME',
'db_type' => 'mysql',
),'db_user_name' => 'root',
'db_password' => 'PASSWORD',
'db_name' => 'DATABASE_NAME',
'db_type' => 'mysql',
'site_url' =>,
etc...
4. Copy all your files to the new server.
5. Go into the <sugarroot/.htaccess> and ensure that the new server URLs are used correctly.
6.You now should be able to use SugarCRM on both the old and the new server without any downtime using the same database on both installs.
Enjoy!
