Migrating configuration files

[Peter D]

Background:
We have been using Sugar CRM for a while now and taken it through a number of updates to reach the current 4.5.0e

The "Live" server and the devlopment server are both experiencing the e-mail problem whereby edits to the text of the e-mail are not saved resulting in e-mails with a recipient, a subject, an attachment and no body text!

As an experiment I installed 4.5.0c using the bitrock installer on a separate machine and took this through to 4.5.0e. This instance does successfully save the changes to the body text.

The question is:
What is the procedure to copy the data and settings on an existing server to a brand new "vanilla" server? The objective of this would be to get the benefits of a clean install i.e. no junk or history from previous versions whilst keeping the data and settings built up over time.

Thanks

[Elmerbug]

Peter,
I think we should start be doing a dump of the sugar database.
mysqldump sugarcrm > <databasebackupfolder>

Once you have done that move that file to the new machine.

Then you will want to move the Cache and Custom folders over to your new server from your sugar root directory.
It's a pain but this is what worked for me.

Now go into you production server:
Admin
Studio
Migrate Custom Fields
Export your fields


Go to your new server and import the database.
mysql sugarcrm < <path and filename> -p

You will probably need to use a password, hence the -p

ok so your database should now be a mirror of your production server.
Go in and import your custom fields that you exported from the production server.



There are a few things that don't work right away but I have found a save and publish on the pages not showing the correct options will usually take care of it.

Good luck.