Database restore

[angolanmade]

I've been trying to upgrade my community version of the sugarcrm to 5.2 from the previous version (5.1) everytime I try to use the upgrade wizard in the admin panel it timesout and it gives me an error. I instead did a fresh install of 5.2 and now im trying to restore my database, however im not having any luck with.

I've tried configuring the the config.php file on the fresh install (5.2) to link to my previous database, however i get the following error when i try to access my crm directory.

Sugar CRM 5.2.0 Files May Only Be Used With A Sugar CRM 5.2.0 Database.

I would greatly appreciate your help

[roblaus]

Usually there are structural changes between versions thus a db check prevents the usage of an old db with a new program. You have two options:

If you have few data only you may transfer the data manually from your old db to the new one. phpmyadmin gives you a fairly comfortable ex- and import routine.

If your system is bigger you need to check for the structural changes (new tables and fields). Then recreate the new fields and tables in your old db and change the table config. This should work but takes some time. And it is NOT recommended to try it on a live system.

The easier way is to find out why the upgrade fails. I just ran one for testing puposes with a fairly large db and it worked without problems. So it is likely that your system configuration is the culprit.

[angolanmade]

Thanks for the quick reply, heres the error that i get when using the upgrade wizard.

Warning: chmod() [function.chmod]: Permission denied in /htdocs/crm/include/utils/sugar_file_utils.php on line 196

Specified directory '' for zip file '/htdocs/crm/cache/upload/SugarCE-Upgrade-5.1.0-to-5.2.0.zip' extraction does not exist.

Thanks again

[roblaus]

try to set everything to 777. (chmod -r 777) Then run the upgrade. Afterwards please read the documentation which directories must have which permissions. This should fix your issue.

[angolanmade]

Roblaus:

I appreciate your help, when you say "set everything to 777) which folders are you refering to? I set the permissions to writable on all the folders as per the instalation instructions. Which included the cache directory and all its files and sub-directories, additionally i've gone ahead and changed the permissions to the include folder and sub-directories to writable and still, im getting the same error!

[andopes]

try to set everything to 777. (chmod -r 777) Then run the upgrade. Afterwards please read the documentation which directories must have which permissions. This should fix your issue.

Hi guys

Instead of execute the command "chmod -R 777" (which contains security issues) you should identify the user and group under which the apache is running.
Then you may execute the command as root:
chown -R user.group /path/to/sugar

Cheers