Data transfer from 4.5.1d to 4.5.1e possible?

[dangelo]

Hello

I'm using on my machine SugarOS 4.5.1d and now I wanted to change the server and therefore I wanted to download the same SugarOS, but I couldn't finde 4.5.1d. Instead I've installed now 4.5.1e and now I have a problem to get my data from the "older" to the "newer" machine.

I'm using phpmyadmin to export and to import my data from mysql .

1. Is there a download-location for 4.5.1d? I can't find it!

2. If there isn't a download-location, how can I get my data from one machine to the other?

Thank you.

Sincerely,
dangelo

[eggsurplus]

Check out the 4.5.1e patch. This should get you upgraded: http://www.sugarforge.org/frs/downlo...tch-4.5.1e.zip

[michaelest]

I did a 4.5.1d to 4.5.1e data transfer just a few weeks ago (we upgraded/moved servers). This is how I did it...
a. Using phpMyAdmin, select your SugarCRM database.
b. Click on the Export tab
c. Under "View dump (schema) of database", make sure all tables are selected (they are by default).
d. Select "SQL" as the export format.
e. In the "structure" and "data" areas, leave default.
[x]Structure
[x] add AUTO_INCREMENT value
[x] enclose table and field names with backquotes

[x] Data
[x] complete inserts
[x] extended inserts
[x] use hexadecimal for binary fields
export type = INSERT
f. Save as file [x]
Don't save it as any type of file, just download it.
g. Click "Go"

The hurdle comes when you go to re-import the data into a new database. phpMyAdmin will have varying limits on the size of the upload file depending on the server you're on. If you have a limitation on your server upload that is less than the exported 'sugarCRM.sql' file, then you are going to have to break up the .sql file into chunks that are no bigger than the upload limit stated by phpMyAdmin. Make sure you keep sql commands and data whole - don't split them arbitrarity. If you have a large database of information, this will be a pain in the a**.

If you are in a shared server environment, your options are limited.

If you have access to a shell prompt, then you can try the alternate method outlined
here

Good luck.