Joomla! Forum - community, help and support

http://blog.phil-taylor.com/2006/02/07/ ... be-easily/
Filed under: Joomla Core — Phil Taylor @ 8:48 pm

DO NOT ATTEMPT THIS IF YOU DONT KNOW WHAT YOU ARE DOING!!! EMPLOY AN EXPERT TO DO IT IF YOU ARE AT ALL UNSURE - MESSING IT UP COULD LOOSE ALL YOUR DATA !!!!!

Today I had to upgrade a customer form Mambo 4.5(1.0.9) to Joomla 1.0.7, this is not for the feint hearted!

Although they had loads of custom components I was only interested in upgrading the core of Mambo, I.e. the database schema and files.

I manually went through and compared the database, table by table, field by field, property by property, index/key by index/key, and compiled a long list of SQL commands that are needed to upgrade the database so it can be used.

I AM RELEASING THIS SCRIPT FOR FREE in the hope it is useful :-)

Here are the steps I took


  1. BACKUP FILES

  2. BACKUP THE DATABASE

  3. BACKUP AGAIN

  4. Overwrite the Mambo files with the Joomla Files

  5. Run my upgrade SQL (Download from http://www.phil-taylor.com/Free )

  6. TEST

  7. Optional: upgrade custom components/modules/mambots


DO NOT ATTEMPT THIS IF YOU ARE UNSURE


This script is provided AS IS and is NOT SUPPORTED by Phil Taylor, Blue Flame IT Ltd. Use at your own risk.

After I have followed these steps my new upgraded site worked perfectly. Bur when I have tried to execute update.sql file I got error saying that some tables already exists. But even without upgrading the database everything worked ok.

Maybe this is because I have tried this on clean installation of mambo 451a.

Is it really necessary to run that upgrade.sql file

probably - the title of my post says FROM Mambo 4.5(1.0.9) which is not the same as Mambo 4.5.1a and therefore you probably will have issues.

Can this update also be run from a 4.5.2 version ??

The clue is in the title :

Mambo 4.5(1.0.9) to Joomla 1.0.7

In other words no :-) :-)

I had to upgrade two sites from Mambo 4.5.2 (last stable release) to Joomla! 1.7 because we were getting attacked and our ISP was seeing the attacks as coming from us.
I upgraded the sites to Joomla! just fine but I didn't copy Joomla! over our current files.
I moved our files to a temp directory then copied the Joomla! files into the hosted directory.
Edited the Joomla! config file to point to the hosted directory.
Then moved any additional modules, components, mambots, images, and files over.
Manually changed the SQL variables for the administrator page/templates.
Everything was working great on the back-end and front-end of the site except the Contacts.
On the back-end the Contacts module works fine and all the contacts are listed under their group but on the front-end of the site if you try to fill the email form out it never gets to the contact and a copy never goes to the sender.
We were/are using SMTP and a hostname and that is how it looks under Global Config.
Is there an SQL value or a config file I need to adjust?

zorro128 wrote: After I have followed these steps my new upgraded site worked perfectly. Bur when I have tried to execute update.sql file I got error saying that some tables already exists. But even without upgrading the database everything worked ok.

Maybe this is because I have tried this on clean installation of mambo 451a.

Is it really necessary to run that upgrade.sql file

kenmcd wrote: The Mambo 4.5 Stable-1.0.9 to Mambo 4.5.1 SQL upgrade file (upgrade45_109to451.sql) has some errors which may be the problem.
There are duplicates for some of the entries made in the 4.014 to 4.5 SQL file (upgrade4014to45.sql).

Commenting-out the duplicates may allow the upgrade to complete properly.
See attached file:  upgrade45_109to451_fixed.sql.txt

More info here:
Migrating Mambo 4.5 Stable-1.0.9 to Joomla 1.04
http://forum.joomla.org/index.php/topic ... #msg140356

Fix:
Some of the entries for the already existing table must be commented out in the SQL update file.
This allows the script to finish without crashing.
Yes, you must run this script - the other changes are needed.

After reading through this thread again I actually looked at the sql upgrade script and noticed it did more then just tweak the admin template table.
So I ran the sql upgrade script and it ran with no problems.
So I've migrated from Mambo 4.5.2 to Joomla 1.7 ran the sql script verified the Global Configurations BUT our Contacts still aren't working.
If you try and fill out a contact email form mail isn't sent.
Is there a config in the MySQL tables that needs to be tweaked?

I am having a problem with backup of my site. I have tried to run sql query which contained my old databse but I got this error:

"#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 19
"

It means that you are running an older version of mysql - just remove that last part about default charsets

Hello

I want to upgrading to Joomla from my old Mambo CMS ... but I'm little confused with the versions. In my backend there's written: Version: 4.5.1 Stable [Three For Rum] 24/09/2004 00:08 GMT ... so can I use this upgrade-tutorial or should I first update to Mambo 4.5.2 (I hope this is still possible!?) and then follow these instructions: http://help.joomla.org/content/view/818/181/

Thanks for any help ... I hope I can soon participate the Joomla Community

Hi Phil
Mambo 4.5(1.0.9) to Joomla 1.0.7 Upgrade Script v1.0 is great and works upgrading 4.5(1.0.9) to Joomla 1.0.11 too.
But I think there is missing one row: because in 4.5(1.0.9) , there is no com_syndicate.

I am wondering if these same rules apply to migrating from Mambo 4.6.1 to Joomla 1.0.12 ?  The main reason I am wanting to migrate is because joomla supports the SEO component that allows individual page titles.  Not having this has REALLY hurt my SEO ratings and possibilities of more traffic.

Any info greatly appreciated,

Phil