Details about this thread
  • State Not Answered
  • Replies 12 replies
  • Subscribers 314 subscribers
  • Views 2446 views
  • Users 0 members are here
Related content from around SugarClub

Migrating customizations from cloud to clean on-site install

Chris Maggiulli

I have configured a local dev environment of SugarCRM Enterprise 8.3.  I was able to get it up and running only with a clean install (without any of our customization's).  I also have an export of our cloud htdocs folder which does contain the customization's.

I was attempting to use the clean install and simply import our customized assets but the job is tedious and I don't know enough about the platforms moving pieces to troubleshoot errors quickly when they arise.  As such I attempted to swap out the htdocs folder of the clean install with the htdocs folder of the asset ( follow this document as a guideline ), and have been able to accomplish the following:

1. Import of the data into local MySQL database

2. Modified the config.php file to point to the local mysql database

3. Modified the config.php file to connect to local elasticsearch

4. Created the necessary .htaccess files

Because I have a clean install running fine locally I know that my web server (and related modules), php (and related modules), and database are installed and configured correctly.  However, after making those changes when I try to access any page locally I get a MySQL error related to a table that doesnt exist (must be a table related to one of the unimported modules).  I've tried to delete the contents of ./cache but still the same error.  Any suggestions on this?  Should I just attempt to create the table manually?

Parents Reply Children
  • 0 Sugar Employee Badge in reply to sophie sun

    Hello Sophie, 

    You are missing a couple of steps. try the following: 

    1 - Unzip the backup and navigate inside the instance folder, where you find the config.php files among several other files 


    2 - From inside the folder start the local webserver running the commands that are explained here: 

    3 - Now you have your local server running, but you need to import your DB from the backup. 


    You can do that with the following commands from the terminal. To make it easier please move the .sugar1030ent.sql file inside the instance directory before.

    $ ssh vagrant
    $ mysqladmin -u root -proot create sugarcrm
    $ mysql -u root -proot sugarcrm < /var/www/html/sugar/sugar1030ent.sql


    * this will import the .sql DB locally and will take a while depending on the DB size

    4 - After it finishes, you need to change the following settings in the config.php file

    'site_url' => 'http://localhost:8080/sugar/',


    'dbconfig' =>
    array (
    'db_host_name' => 'localhost',
    'db_host_instance' => 'SQLEXPRESS',
    'db_user_name' => 'root',
    'db_password' => 'root',
    'db_name' => 'sugarcrm',
    'db_type' => 'mysql',
    'db_port' => '',
    'db_manager' => 'MysqliManager',
    ),


    5 - Open the hidden file .htaccess in the instance root and where you see this: 

    <IfModule mod_rewrite.c>

        Options +FollowSymLinks
        RewriteEngine On
        RewriteBase /

    Add this: 

    <IfModule mod_rewrite.c>

        Options +FollowSymLinks
        RewriteEngine On
        RewriteBase /sugar


    After this, the instance should be up and accessible in the following
    URL

     http://localhost:8080/sugar/


    I hope this helps.