Data Upgrade/Migration Considerations

Hey Germi,

We migrated to a new host awhile back, but are just now getting around to putting our music collection back up (it's very large). Because it's been awhile, I know the extension version we were using is really outdated.

Right now we are running Joomla 2.5.22 but plan to migrate to Joomla 3 in the next couple of months. Our Music Collection database/files are from Music Collection 2.3.1. We are throwing around ideas to try and figure out the best way to migrate this data, and was wondering if we could get your input?

1. Do we need to install Music Collection 2.3.1, then follow the upgrade process to 2.4.3? Or can we just do a fresh install of 2.4.3 and then replace with our old database tables/files? We see from your site that it looks like there may have been database changes between 2.3.1 and 2.4.0, so we weren't sure which would work

2. Since the music collection packages for Joomla 2.5 and Joomla 3 are separate, does that mean it will be necessary to uninstall the Joomla 2.5 extension, upgrade to Joomla 3, and then install the Joomla 3 compatible version? So is it possible to migrate the data from Joomla 2.5 over to Joomla 3? And if so, would we have to re-import all the files (songs/albums) or just copy over the database tables?

3. Is it possible to take the data from our Music Collection 2.3.1 version and import it directly into a Joomla 3 install?

Any insight you can provide would be most appreciated. Thank you!

Eric & Angela
Responses (2)
  • Accepted Answer

    Thursday, June 19 2014, 07:24 PM - #Permalink
    1. well, the DB in version 2.4.3 has a few new fields in the DB. so it may be better to install first 2.3.1, migrate the tables, and THEN make the upgrade.

    2. the DB structure is the same, so you don't need to import/export it. actually you probably don't even need to uninstall the old version first. I mean, you can upgrade joomla, then install the music collection for Joomal 3 (I mean MC 2.3.1), and then install the 2.4.3 and make the upgrade.

    3. well, it would be possible if it wasn't for the new fields on the DB. in any case, the new DB fields are not much, so if you prefer you can do it your way, and then access your DB and add the new fields, which are..

    ALTER TABLE  `#__muscol_artists` ADD  `tags` VARCHAR( 255 ) NOT NULL

    ALTER TABLE  `#__muscol_songs` ADD  `tags` VARCHAR( 255 ) NOT NULL , ADD  `external_type` VARCHAR( 255 ) NOT NULL , ADD  `external_id` INT( 11 ) NOT NULL

    ALTER TABLE  `#__muscol_albums` ADD  `external_type` VARCHAR( 255 ) NOT NULL , ADD  `external_id` INT( 11 ) NOT NULL
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, June 19 2014, 08:08 PM - #Permalink
    That certainly gives us plenty to work with in making a decision. Thanks as always! :)
    The reply is currently minimized Show
Your Reply