Upgrading Sugar CRM

Upgrading Sugar CRM should not be a painful process, but it can be, as I found out.
Unlike some of the older releases the current stable version does not include either an upgrade option or any instructions on doing it, while the documentation link points to the wrong place.
Fortunately I had taken a backup of my entire DB before I started, so it wasn’t too bad 🙂
In any case if you want to avoid this kind of headaches:
1 – Take a backup of your Sugar CRM database
2 – Go here
3. Read the instructions
4. Grab the correct .sql file
5. Import it:
mysql -uusername -ppassword database< 2.5-2.5.1_open_db_upgrade.sql Edit to taste
6 Run the installer for the latest version
Make sure you DO NOT create new tables or drop any existing ones
Login as the "admin" user. You'll be prompted to run a couple of upgrades via the admin panel to finalise the install.