import information

[deemurphyus]

My company had sugar 3 installed on a windows operating system. I just installed Sugar 4.5 on Linux for them. Is there a way to import information from their old install into the new one.

Dee

[sanjaykatiyar1]

My company had sugar 3 installed on a windows operating system. I just installed Sugar 4.5 on Linux for them. Is there a way to import information from their old install into the new one.

Dee

You can use database dump from previous install to new one.
But you should not dump the whole database as some tables (config, relationships, versions...)contains the sugar related information.

[deemurphyus]

I s the database dump done from each system?

Or is there something on the panel that can be used for this process.

Dee

[deemurphyus]

Can the import of the tables be done via the control panel?

Dee

[Arpee Ong]

deemurphyus - currently there is no facility to backup/restore SugarCRM database through the Admin Panel of SugarCRM. The Backup facility that is currently native with SugarCRM OS is for file backups and not the Database.

To backup a Database, you will need a database Client such as PHPMyAdmin, your hosting might have provided you with that, if this is a local installation, then pls download/install PHPMyAdmin.

To Backup SugarCRM OS DB.

1. Open PHPMyAdmin
2. Select your SugarCRM DB from the drop down list of DB's on the left panel
3. Click Export
4. On the Table Selection, Click Select ALL
5. Click Save As File so you will have a local copy. You may also choose compression options such as ZIP, Gzippde or Bzipped
6. Save the SQL Backup

To Restore SugarCRM OS DB on another server/installtion.

1. Open PHPMyAdmin
2. Select your SugarCRM DB from the drop down list of DB's on the left panel
3. Click Import
4. Browse for the SQL file then Execute the Restore Operation

The Server where you restored the DB backup will be the exact replica of the Source SugarCRM Os install. I dont see any configuration on the DB that might break when you use a DB on another existing SugarCRM installation provided that they are the same versions with same set of files.

You have to self investigate which tables are compatible between Sugar 3 and 4.5, and alter the instruction above on the Backup part, Change Number 4 (Select All Table) - Just select the appropriate tables that you find compatible, make multiple Table Selection on the PHPMyAdmin Backup screen by holding CTRL while selecting each tables.