How to use existing database on new installation?

**cappa** · 2006-09-11, 12:11 AM

Basically I have this Sugarcrm 4.5 database (existing) and I need it to work with a new installation of Sugarcrm 4.5. The sugarcrm 4.5 database (existing) was upgraded from 4.2.1 using the provided upgrade SQL script. I know this isn't the correct way of doing things, but it's not my doing. What can I do at this point to remedy the situation? The new installation refuses to recognize the existing (older) database. Thanks in advance.

**Scott_Savage** · 2006-09-11, 01:17 AM

Do an install of the new 4.5 edition on another database (eg. sugarcrm2) and then compare the tables. From what I have seen there are not a whole lot of change between the database formats. A couple of things like the user_password column and a couple of other columns, but on the whole not really. Have a look at the main config table as well for any differences. I know it sounds tough to go through each table, but there aren't that many tables and I think most you will find no differences at all. If you had an error message you could post up here that would help too.

**Markku** · 2006-09-11, 09:15 AM

It might be enough if you update config table by running this SQL statement:

Code:

UPDATE `config` SET value = '4.5.0' WHERE name = 'sugar_version';

I created small SQL script which you can use to downgrade 4.5.0 database to version 4.2.1. If updating config table is not enough you could try to downgrade your current 4.5.0 database and files to previous and then use Upgrade Wizard to update to 4.5.0.

Script is available here, but use it with caution.
http://www.sugarcrm.com/forums/showthread.php?p=51410

As a reference enclosed please find my copy of upgrade_sugar421_to_450.sql which was generated by Upgrade Wizard. I added two statement (last two), but commented them. The script shows what changes are done to database when upgrading from 4.2.1 to 4.5.0.