How to convert an existing Mambo website to MiaCMS?

In this section we are going to show you how to migrate your existing Mambo website to MiaCMS.

Please remember that it is highly recommended to backup your existing Mambo web site before you proceed with the migration process.

First, you should download the official Mambo to Mia conversion patch.

Once you have done that, you'll have to take your website offline. This can be done through your Administrative area -> Site -> Global Configuration -> Site Offline (YES).

The next step is to remove the following files and folders from the installation directory of your Mambo website:

• mambots/editors/mostlyce (the entire folder)
• mambots/editors/mostlyce.php
• mambots/editors/mostlyce.xml

Next, use FTP to upload the extracted conversion patch files into your existing Mambo 4.6.2+ installation directory. You should let the files with the same names in order to overwrite the existing ones.

To complete the conversion process, you have to execute few MySQL queries in your Mambo database. To do that, you can use the PhpMyAdmin tool in your cPanel. Once you have opened the PhpMyAdmin tool, select your Mambo database and click on the SQL button. In the query field execute the following queries as displayed below:

• UPDATE mos_templates_menu
  SET template='miacms_admin'
  WHERE template='mambo_admin_blue';
• CREATE TABLE `mos_poll_charts` (
    `id` int(11),
    `bar_type` varchar(25) NOT NULL default 'bar_outline',
    `bar_color` varchar(6) NOT NULL default '45E56F',
    `width` int(11) NOT NULL default '300',
    `height` int(11) NOT NULL default '300',
    `title_font_size` int(11) NOT NULL default '12',
    PRIMARY KEY (`id`)
  );
• ALTER TABLE `mos_polls`
  ADD COLUMN `use_chart_api` int(11) NOT NULL default '0' AFTER `lag`;
• ALTER TABLE `mos_comment` ADD COLUMN `website` varchar( 250 ) NOT NULL default '' AFTER `name` ,
  ADD COLUMN `email` varchar( 100 ) NOT NULL default '' AFTER `name` ,
  ADD COLUMN `user_id` varchar( 250 ) NOT NULL default '' AFTER `name` ,
  ADD COLUMN `spam` tinyint( 1 ) NOT NULL default '0';

Please note that if you have changed the default prefix of your tables (mos_), you should edit the queries above to match the real name of your tables. For example, if you have changed the tables prefix to "smth_", you have to change the first line of each query to match your particular table names - UPDATE smth_templates_menu,  UPDATE smth_templates_menu, etc.

Once you have executed the last query, you will have to add the following lines to the configuration.php file of your Mambo application: 

• $mosConfig_enable_stats_charting = '0';
• $mosConfig_yui_version = '2.5.2';
• $mosConfig_yui_loader='local_min';

The migration is now complete. You can put your website back online from your Administrative area -> Site -> Global Configuration -> Site Offline (NO) and enjoy your new MiaCMS website!