How to backup data - not files or DB tables

**organi** · 2005-10-16, 04:30 PM

How can I backup the data and restore it in another SugarCRM version?

I'm currently running 3.5.0c. Since I cannot upgrade from 3.5.0c to 3.5.1 due to an Upgrade Wizard problem - I'm trying to backup all existing data, install a fresh 3.5.1 and then restore the data.

However, the Admin's Backup tool only backs up the application files, not the data. Restoring the application files after installing 3.5.1 would only bring the old 3.5.0c application.

Also, making a backup copy of the actual 3.5.0c DB tables that contain our data and restoring them after I install 3.5.1, create errors of incompatibility between the old DB tables format and the expected new format.

Is there a way to backup only the data and then restore it?

**ldebernardini** · 2005-10-17, 06:32 AM

I did something like thise upgradingi from 2.5 to 3.0. I Backed up the DB using MySQL tools and copied in a different location all the Sugar directory.

I Installed the new Sugar version from rough without creating the DB and, obviously, populating it. After this I used the script contained in the Sugar upgrade directory to modify the DB structure and align it to the new Sugar version.

It worked.

Luigi

**organi** · 2005-10-17, 08:21 PM

Originally Posted by ldebernardini

After this I used the script contained in the Sugar upgrade directory to modify the DB structure and align it to the new Sugar version.

It worked.

Luigi

What is the script's filename?

**organi** · 2005-10-19, 02:56 AM

Yes, it works!

Here are the steps to manually upgrade from 3.5.0c to 3.5.1 if the Upgrade Wizard fails:
* Backup the 3.5.0c DB
* Backup the 3.5.0c application files
* Install a fresh 3.5.1
* Drop the newly installed 3.5.1 DB
* Restore the 3.5.0c backup DB which contains your data
* Run the SQL code in /upgrade/3.5.0a_to_3.5.1_mysql.sql
* Manually edit the config.php file with your config settings

Done!
Thanks to all of you out there for your help and suggestions.