mySQL database move from web to local disk

[budo]

Hi,

I have installed SUGAR CRM with mySQL on webserver:
Sugar Community Edition Version 5.2.0j (Build 5804)

Because it is too slow for me I decided to start using local disk c:/

I installed:
FastStack Windows Installer for 5.5.0R with MySQL
http://www.sugarforge.org/content/do...-installer.exe

It works fine on c:/

I exported database _Sugar from web server and imported to base _Sugar on hard drive c:/ using phpMYADMIN.

Unfortunatelly i started Sugar and have:
Sugar CRM 5.5.0RC4 Files May Only Be Used With A Sugar CRM 5.5.0RC4 Database.

Anyone help, please.
I would like to know how to move database both directions as I am planning to move localdisk database on webserver in 2-3 months. But at the moment as described above is very hectic.

Stef

Stef

[salesagility]

5.5 and 5.2 are have different database schemas ... if you installed on 5.2 database ... then get a 5.2 stack, install sugar 5.2, restore the database ... and then it'll pick up the database ... otherwise you are creating a lot of unnecessary work for yourself

[budo]

Right, so should I upgrade my SUGARCRM from 5.2 (I have now) to 5.5 on the web?
Than export database and install on fastrack 5.5 on local disk?

is that right?

Stef

[salesagility]

5.5 is not production ready ... you will get too many problems with it this early

You should uninstall the 5.5 stack

Install the 5.2 stack

Install sugar 5.2

restore the 5.2 database

edit the config.php to point to the restored db

[budo]

thanks for message.

one more thing: what should I edit in config.php - I am not a programmer so I am afraid I need detailed explanation, please :-).

Stef

[salesagility]

You should look for these lines:

'db_host_name' => 'localhost',
'db_host_instance' => 'MySQLInstance',
'db_user_name' => 'BD_Admin_username',
'db_password' => 'database_password',
'db_name' => 'sugar52k',
'db_type' => 'mysql',

It is most likely that you will only have to change the 'db_name' => 'the_name_of_your_5.2_database',

[budo]

thanks a lot. I will try to do it in the evening:-)

you are VERY helpful:-)

stef

[budo]

UPS!

can't find windows stack pack with mySQL!

Doeas it have only mssql?
http://www.sugarforge.org/frs/?group_id=79

I have my database on the web which is MYSQL! and all the data are in it.

What to do?

Stef

[budo]

I found fast trak with mysql for Windows. Installed and it works.
Than I imported using phpmyadmin database. Import was successful.

but I have problem with config.php

On hard drive I found several config.php files but I edited:
...sugarcrm\htdocs\sugarcrm\config.php

is it good file?

than I changed values as you described and it doesn't work.
So, this is a part of original (C;/drive fastrack instance of Sugar):
'db_host_name' => 'localhost',
'db_host_instance' => 'SQLEXPRESS',
'db_user_name' => 'root',
'db_password' => 'XXX',
'db_name' => 'sugarcrm',
'db_type' => 'mysql',

on the web server this part looked like (before I exported database):
'db_host_name' => 'XX.146.68.XXX',
'db_host_instance' => 'SQLEXPRESS',
'db_user_name' => 'XXX_admin',
'db_password' => 'XXX',
'db_name' => 'XXX_Sugar',
'db_type' => 'mysql',

What should I change in new config.php on my hard drive the way that old database would work, please?

Stef

[salesagility]

It looks as if you have the correct config.php.

What happens if you try to run the sugar installer?